CREATE QHBSECUREROLE

CREATE QHBSECUREROLE — assign a role of security administrator to a user

Synopsis

CREATE QHBSECUREROLE
    [ qhb_db_admin | qhb_dbms_admin ]
    FOR user_name
    [ FOR database_name ]

Description

CREATE QHBSECUREROLE allows to assign a role of security administrator to a user.

There are two supported assignment: qhb_db_admin and qhb_dbms_admin. These are "DB Administrator" and "DBMS Administrator", respectively.

Parameters

FOR user_name

The name of the existing user.

FOR database_name

When the role qhb_db_admin (DB Administrator) is assigned, you should also specify the name of the existing database. It is not necessary for DBMS Administrator role assigning.

Examples

To assign a role of DBMS Administrator to a user:

CREATE QHBSECUREROLE qhb_dbms_admin FOR user1;

To assign a role of DB Administrator for the database database1 to a user:

CREATE QHBSECUREROLE qhb_db_admin FOR user1 FOR database1;

Compatibility

There is no CREATE QHBSECUREROLE statement in the SQL standard.