> ## Documentation Index > Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # SHOW USERS export const InternalLink = ({version, path = "", children, ...props}) => { let detectedVersion = version || "stable"; if (typeof window !== 'undefined' && !version) { const match = window.location.pathname.match(/\/docs\/([^/]+)/); if (match) { detectedVersion = match[1]; } } const normalizedPath = path.startsWith("/") ? path.slice(1) : path; return {children} ; }; The `SHOW USERS` statement lists the users for all databases. Since the keywords `ROLES` and `USERS` can now be used interchangeably in SQL statements for enhanced PostgreSQL compatibility, `SHOW USERS` is now an alias for `SHOW ROLES`. ## Synopsis show_users syntax diagram ## Required privileges The user must have the `SELECT` privilege on the `system.users` and `system.role_members` tables. ## Example ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW USERS; ``` ``` username | options | member_of | estimated_last_login_time -----------+----------------+-----------+------------------------------ admin | {CREATEROLE} | {} | NULL carl | {NOLOGIN} | {} | NULL petee | {} | {} | 2025-08-04 19:18:00.201402+00 root | {CREATEROLE} | {admin} | NULL (4 rows) ``` Alternatively, within the built-in SQL shell, you can use the `\du` shell command: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > \du ``` ``` username | options | member_of | estimated_last_login_time -----------+----------------+-----------+------------------------------ admin | {CREATEROLE} | {} | NULL carl | {NOLOGIN} | {} | NULL petee | {} | {} | 2025-08-04 19:18:00.201402+00 root | {CREATEROLE} | {admin} | NULL (4 rows) ``` ## See also * `CREATE USER` * Manage Users