Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

2.2.1 Granting the DBA privilege to users who manage user privileges

Executor: HiRDB administrator

The GRANT statement, which is a definition SQL statement, is used to grant the DBA privilege to a user who will manage user privileges. This task is required when the user who will manage user privileges is not a HiRDB administrator.

Example
Grant the DBA privilege to the user who will manage user privileges (authorization identifier: USER001, password: HIRDB001):
  GRANT DBA TO USER001 IDENTIFIED BY HIRDB001