SVL_USER_INFO - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SVL_USER_INFO

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

SVL_USER_INFO is visible only to superusers. For more information, see Visibility of data in system tables and views.

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. UNRESTRICTED 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.
sessiontimeout integer The maximum time in seconds that a session remains inactive or idle before timing out. 0 indicates that no timeout is set. For information about the cluster's idle or inactive timeout setting, see Quotas and limits in Amazon Redshift in the Amazon Redshift Management Guide.
external_id text Unique identifier of the user in the third-party identity provider.

Sample queries

The following command retrieves user information from SVL_USER_INFO.

SELECT * FROM SVL_USER_INFO;