SVV_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).

SVV_USER_INFO

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

SVV_USER_INFO is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.

Table columns

Column name Data type Description
user_name text The user name for the role.
user_id integer The user ID for the user.
createdb boolean A value that indicates whether the user has permissions to create databases.
superuser boolean A value that indicates whether the user is a superuser.
catalog_update boolean A value that indicates whether the user can update system catalogs.
connection_limit text The number of connections that the user can open.
syslog_access 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_timestamp timestamp The timestamp for the last data definition language (DDL) create statement run by the user.
session_timeout 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_user_id text Unique identifier of the user in the third-party identity provider.

Sample queries

The following command retrieves user information from SVV_USER_INFO.

SELECT * FROM SVV_USER_INFO;