# LIST USERS

## Syntax <a href="#synopsis" id="synopsis"></a>

```sql
[ LIST | SHOW ] USERS;
```

## Description <a href="#description" id="description"></a>

This command provides a list of [#user](https://docs.deltastream.io/overview/core-concepts/access-control#user "mention")s that are part of the current [#organiation](https://docs.deltastream.io/overview/core-concepts/access-control#organiation "mention").

Users are listed only if the current [#role](https://docs.deltastream.io/overview/core-concepts/access-control#role "mention") has `USAGE` privileges on the organization.

## Examples <a href="#example" id="example"></a>

#### List current user without an organization

```sh
<no-organization># LIST USERS;
+-------------+--------------+-------------+------------------------------------------+------------+
|  Given Name |  Family Name |  Is Current |  Email                                   |  Locale    |
+=============+==============+=============+==========================================+============+
| user1       | fam1         | true        | useremail00b4-0e18-4edd@deltastream.io   | en         |
+-------------+--------------+-------------+------------------------------------------+------------+
```

#### List users in an organization

```sh
<no-organization># USE ORGANIZATION my_org;
+--------------+---------+----------+------------------------------+
|  Type        |  Name   |  Command |  Summary                     |
+==============+=========+==========+==============================+
| organization | my_org  | USE      | using organization "my_org"  |
+--------------+---------+----------+------------------------------+
<no-db>/<no-store># LIST USERS;
+-------------+--------------+-------------+------------------------------------------+------------+
|  Given Name |  Family Name |  Is Current |  Email                                   |  Locale    |
+=============+==============+=============+==========================================+============+
| user1       | fam1         | true        | useremail00b4-0e18-4edd@deltastream.io   | en         |
+-------------+--------------+-------------+------------------------------------------+------------+
| user2       | fam2         | false       | useremail224b-e672-498d@deltastream.io   | en         |
+-------------+--------------+-------------+------------------------------------------+------------+
```