System views
The following table describes the views that display system information. You must have administrator privileges to display these views.
View name | Description | Output | Ordered by | nzsql |
---|---|---|---|---|
_v_sys_group_priv | Returns a list of all defined group privileges | GroupName, ObjectName, DatabaseName, Objecttype, gopobjpriv, gopadmpriv, gopgobjpriv, and gopgadmpriv | DatabaseName, GroupName, and ObjectName | \dpg <group> |
_v_sys_index | Returns a list of all system indexes | objid,SysIndexName, TableName, and Owner | TableName, and SysIndexName | \dSi |
_v_sys_priv | Returns a list of all user privileges. This list is a cumulative list of all groups and user-specific privileges. | UserName, ObjectName, DatabaseName, aclobjpriv, acladmpriv, aclgobjpriv, and aclgadmpriv | DatabaseName, and ObjectName | \dp <user> |
_v_sys_table | Returns a list of all system tables | objid, SysTableName, and Owner | SysTableName | \dSt |
_v_sys_user_priv | Returns a list of all defined user privileges | UserName, ObjectName, DatabaseName, ObjectType, uopobjpriv, uopadmpriv, uopgobjpriv, and uopgadmpriv | DatabaseName, UserName, and ObjectName | \dpu <user> |
_v_sys_view | Returns a list of all system views | objid, SysViewName, and Owner | SysViewName | \dSv |