List users in Redshift

Query below returns list of users in current database.


select usesysid as user_id,
       usename as username,
       usecreatedb as db_create,
       usesuper as is_superuser,
       valuntil as password_expiration
from pg_user
order by user_id


  • user_id - id of the user
  • username - user name
  • db_create - flag indicating if user can create new databases
  • is_superuser - flag if user have superuser privileges
  • password_expiration - date of user password expiration


  • One row represents one user in the database
  • Scope of rows: all users in the database
  • Ordered by user id

Sample results

Those results show that there are 4 users in current database.

sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.