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;