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

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

For any one or more (or all) [users](/content/security/sec_concepts#security-concepts-users) and
[roles](/content/security/sec_concepts#security-concepts-roles) 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) (users only)

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

```sql title="SHOW SECURITY Syntax" theme={null}
SHOW SECURITY [FOR <user name | role name>,...]
```

## Examples

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

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

To show the permissions, roles, and *resource groups* for the **analyst** role:

```sql SHOW SECURITY FOR Role Example theme={null}
SHOW SECURITY FOR analyst
```

To show the permissions, roles, *resource groups*, and *default schema* for the
**anonymous** user and the **public** role:

```sql SHOW SECURITY FOR Multiple Users/Roles Example theme={null}
SHOW SECURITY FOR anonymous, public
```

To show all users & roles:

```sql SHOW SECURITY FOR All Users/Roles Example theme={null}
SHOW SECURITY
```


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