Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

SVL_USER_INFO

You can retrieve data about Amazon Redshift database users with the SVL_USER_INFO view.

Table Columns

Column Name Data Type Description
usename text The user name for the role.
usesysid integer The user ID for the user.
usecreatedb boolean A value that indicates whether the user has permissions to create databases.
usesuper boolean A value that indicates whether the user is a superuser.
usecatupd boolean A value that indicates whether the user can update system catalogs.
useconnlimit text The number of connections that the user can open.
syslogaccess text A value that indicates whether the user has access to the system logs. The two possible values are RESTRICTED and UNRESTRICTED. RESTRICTED means that users that are not superusers can see their own records. UNRESTICTED means that user that are not superusers can see all records in the system views and tables to which they have SELECT privileges.
last_ddl_ts timestamp The timestamp for the last data definition language (DDL) create statement run by the user.

Sample Queries

The following command retrieves user information from SVL_USER_INFO.

SELECT * FROM SVL_USER_INFO;

On this page: