IBM PureData System for Analytics, Version 7.1
IBM PureData System for Analytics, Version 7.1
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 |