DROP QHBSECUREROLE

DROP QHBSECUREROLE — remove an assignation of a role of security administrator

Synopsis

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

Description

DROP QHBSECUREROLE allows to remove an assignation of a role of security administrator for a user.

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

This command does not remove a user from the system; it only changes privileges of this user.

Parameters

FOR user_name

The name of the existing user.

FOR database_name

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

Examples

To drop an assignation of a role of DBMS Administrator for a user:

DROP QHBSECUREROLE qhb_dbms_admin FOR user1;

To drop an assignation of a role of DB Administrator for the database database1:

DROP QHBSECUREROLE qhb_db_admin FOR user1 FOR database1;

Compatibility

There is no DROP QHBSECUREROLE statement in the SQL standard.