Hitachi

Hitachi Advanced Database Setup and Operation Guide


B.13 Content of SQL_USERS

SQL_USERS stores HADB user information. Each row stores information on one HADB user.

The following table describes the content of SQL_USERS.

Table B‒15: Content of SQL_USERS

No.

Column name

Data type

Stored information

1

USER_NAME

VARCHAR(100)

HADB user's authorization identifier

2

USER_ID

SMALLINT

HADB user's user ID

3

DBA_PRIVILEGE

CHAR(1)

Whether the user has the DBA privilege

'Y': Has the DBA privilege.

'N': Does not have the DBA privilege.

4

CONNECT_PRIVILEGE

CHAR(1)

Whether the user has the CONNECT privilege

'Y': Has the CONNECT privilege.

'N': Does not have the CONNECT privilege.

5

SCHEMA_PRIVILEGE

CHAR(1)

Whether the user has the schema definition privilege

'Y': Has the schema definition privilege.

'N': Does not have the schema definition privilege.

6

CREATE_TIME

TIMESTAMP

HADB user creation date and time

7

AUDIT_ADMIN_PRIVILEGE

CHAR(1)

Whether the user has the audit admin privilege

'Y': Has the audit admin privilege

'N': Does not have the audit admin privilege

8

AUDIT_VIEWER_PRIVILEGE

CHAR(1)

Whether the user has the audit viewer privilege

'Y': Has the audit viewer privilege

'N': Does not have the audit viewer privilege