11.7.1 Granting user privileges and the schema operation privilege to HADB users

To grant user privileges and the schema operation privilege, use the GRANT definition SQL statement.

The GRANT statement must be executed by an HADB user possessing the DBA privilege and CONNECT privilege.

The following shows examples of granting user privileges and the schema operation privilege to an HADB user.

Specification example 1

The DBA privilege, CONNECT privilege, and schema definition privilege are granted to the HADB user ADBUSER02.

GRANT DBA,CONNECT,SCHEMA TO "ADBUSER02"

Specification example 2

The CONNECT privilege and schema definition privilege are granted to HADB users ADBUSER03 and ADBUSER04.

GRANT CONNECT,SCHEMA TO "ADBUSER03","ADBUSER04"

For details about the GRANT statement, see GRANT (grant privileges) in Definition SQL in the manual HADB SQL Reference.

Important

An HADB user cannot have both the audit admin privilege and the DBA privilege. This means that you cannot grant the DBA privilege to an HADB user who has audit admin privilege.

To Page Top