2.7.1 Privilege types
To operate an HADB server, an HADB user needs various types of privileges.
When an HADB user tries to perform operations on an HADB server, an error occurs if the HADB user does not have the required privileges. Therefore, by granting only the privileges that are needed for the operations that the applicable HADB user will perform, you can reduce the risk of unauthorized operations.
An HADB user can have multiple privileges. Privileges can be classified roughly into the following four types:
-
User privileges
For details, see 2.7.2 User privileges.
-
Schema operation privilege
For details, see 2.7.3 Schema operation privilege.
-
Audit privilege
For details, see 2.7.4 Audit privilege.
-
Access privilege
For details, see 2.7.5 Access privileges.
- Note
-
To grant or revoke a privilege, execute the GRANT or REVOKE definition SQL statement.