> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW SECURITY FOR User

<a id="sql-security-user-mgmt-show" />

For any one or more (or all) [users](/content/security/sec_concepts#security-concepts-users) in the
system, the following can be listed:

* [permissions](/content/security/sec_concepts#security-concepts-permissions)
* [roles](/content/security/sec_concepts#security-concepts-roles)
* [resource groups](/content/rm/concepts#rm-concepts-resource-groups)
* [default schema](/content/concepts/schemas#schema-default)

In addition, permissions, roles, & resource groups will be listed recursively
for the roles the specified users have and the roles those roles have, etc.
This allows the full set of permissions for a given user, both direct &
inherited, to be viewed with one command.

```sql title="SHOW SECURITY FOR User Syntax" theme={null}
SHOW SECURITY FOR <user name>,...
```

## Examples

To show the permissions, roles, *resource group*, and
*default schema* for user **jsmith**:

```sql SHOW SECURITY FOR User Example theme={null}
SHOW SECURITY FOR jsmith
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.