Group public views
About this task
During database initialization, you're granted the group public list and select privileges for system views that retrieve information about users.
The following table describes
some common system views and the type of information that the view
provides. In some cases, the view returns more than the information
listed in the table.
| View name | Data returned |
|---|---|
| _v_aggregate | Objid, aggregate name, owner, and create date |
| _v_database | Objid, Database name, owner, and create date |
| _v_datatype | Objid, data type, owner, description, and size |
| _v_function | Objid, function name, owner, create date, description, result type, and arguments |
| _v_group | Objid, Group name, owner, and create date |
| _v_groupusers | Objid, Group name, owner, and user name |
| _v_operator | Objid, operator, owner, create date, description, opr name, opr left, opr right, opr result, opr code, and opr kind |
| _v_procedure | Objid, procedure, owner, create date, object type, description, result, number of arguments, arguments, procedure signature, built in, procedure source, proc, executed as owner |
| _v_relation_column | Objid, object name, owner, create date, object type, attr number, attr name, attr type, and not null indicator |
| _v_relation_column_def | Objid, object name, owner, create date, object type, attr number, attr name, and attr default value |
| _v_relation_keydata | Database owner, relation, constraint name, contype, conseq, att name, pk database, pk owner, pk relation, pk conseq, pk att name, updt_type, del_type, match_type, deferrable, deferred, constr_ord |
| _v_sequence | Objid, seq name, owner, and create date |
| _v_session | ID, PID, UserName, Database, ConnectTime, ConnStatus, and LastCommand |
| _v_table | Objid, table name, owner, and create date |
| _v_table_dist_map | Objid, table name, owner, create date, dist attr number, and dist attr name |
| _v_user | Objid, user name, owner, valid until date, and create date |
| _v_usergroups | Objid, user name, owner, and group name |
| _v_view | Objid, view name, owner, create date, rel kind, rel checks, rel triggers, has rules, unique keys, foreign keys, references, has p keys, and number attributes |
The following table describes some views that show
system information. You must have administrator privileges to display
these views.
| View name | Output |
|---|---|
| _v_sys_group_priv | GroupName, ObjectName, DatabaseName, Objecttype, gopobjpriv, gopadmpriv, gopgobjpriv, and gopgadmpriv |
| _v_sys_index | objid, SysIndexName, TableName, and Owner |
| _v_sys_priv | UserName, ObjectName, DatabaseName, aclobjpriv, acladmpriv, aclgobjpriv, and aclgadmpriv |
| _v_sys_table | objid, SysTableName, and Owner |
| _v_sys_user_priv | UserName, ObjectName, DatabaseName, ObjectType, uopobjpriv, uopadmpriv, uopgobjpriv, and uopgadmpriv |
| _v_sys_view | objid, SysViewName, and Owner |