2.7.7 Scope of information in dictionary tables and system tables that can be referenced by HADB users
An HADB user who has the CONNECT privilege can reference information about the schema objects stored in dictionary tables and system tables (but not update or otherwise manipulate the data). However, the scope of information the HADB user can reference in the dictionary tables and system tables depends on the privileges granted to the HADB user. The following explains the key information HADB users can reference according to their privileges:
- HADB users who have the DBA privilege
-
These users can reference all information stored in dictionary tables (except for SQL_AUDITS) and system tables.
- HADB users who do not have the DBA privilege
-
These users can reference the definition information they themselves have defined (based on the authorization identifier that was used for the current connection to the HADB server). These users can also reference the following definition information even if it was defined by another HADB user:
-
Information about schema objects such as tables and indexes for which they have access privileges, and information about the schema of these schema objects
-
Information about schema objects for which access privileges are permitted by PUBLIC specification, and information about the schema of these schema objects
-
- HADB users who have the audit admin privilege
-
These users can reference information subject to auditing by the audit trail facility (audit target definition information stored in the SQL_AUDITS dictionary table). Even without access privileges, these users can also reference some information about schema objects defined by other HADB users and information about the schema of these schema objects.
For details about the scope of information in dictionary tables and system tables that can be referenced by HADB users, see the following subsections: