amazon-redshiftHow do I list users on Amazon Redshift?
To list users on Amazon Redshift, you can use the pg_user
system view. This view contains information about all users that have been created in the current database.
Example
SELECT usename, usesysid, usecreatedb, usesuper, valuntil
FROM pg_user;
Output example
usename | usesysid | usecreatedb | usesuper | valuntil
---------+----------+-------------+----------+----------
user1 | 10 | t | t |
user2 | 11 | t | f |
user3 | 12 | f | f |
The code above will list all the users in the current database, along with their system ID, their ability to create databases, their ability to use superuser privileges, and the expiration date of their account.
Code explanation
-
SELECT usename, usesysid, usecreatedb, usesuper, valuntil
: This is the SELECT statement that will retrieve the list of users in the current database. The columns specified in this statement are the username, system ID, ability to create databases, ability to use superuser privileges, and expiration date of the account. -
FROM pg_user
: This is the FROM clause that specifies the source of the data, which is thepg_user
system view.
Helpful links
More of Amazon Redshift
- How do I use Amazon Redshift RSQL to query data?
- How do I use the Amazon Redshift YEAR function?
- How can I use Amazon Redshift UNION to combine data from multiple tables?
- How can I monitor Amazon RDS using Zabbix?
- How can I handle divide by zero errors when using Amazon Redshift?
- How do I use Amazon Redshift with YouTube?
- How do I set up Amazon RDS with Multi-AZ for high availability?
- How do I use Amazon Redshift window functions?
- How can I use Amazon Redshift to store and process unstructured data?
- How do I convert an Amazon Redshift timestamp to a date?
See more codes...