> ## 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

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

* [permissions](https://docs.kinetica.com/content/security/sec_concepts.md#security-concepts-permissions)
* [roles](https://docs.kinetica.com/content/security/sec_concepts.md#security-concepts-roles)
* [resource groups](https://docs.kinetica.com/content/rm/concepts.md#rm-concepts-resource-groups)
* [default schema](https://docs.kinetica.com/content/concepts/schemas.md#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.