GRANT USER Statement (grant_user_statement)

The GRANT USER statement (grant_user_statement) grants another database user the owner privilege that the database system administrator or a database administrator (DBA user) has over a database user.

Structure

Syntax Syntax

<grant_user_statement> ::=
  GRANT USER <granted_users>
    [FROM <user_name>] TO <user_name>

<granted_users> ::=
  <user_name>,...
| *

End of the code.

Explanation

The current user must be a database administrator (DBA user).

The user names specified after the FROM and TO keywords must be different and must identify DBA users. If FROM <user_name> is not specified, the current database user is assumed implicitly.

The database users specified after the GRANT USER keywords must exist and must not be a member of a user group. They must have the RESOURCE user or STANDARD user class. The FROM user must have the owner privilege for these database users. If * is specified, the GRANT USER statement affects all database users for which the FROM user has the owner privilege.

The FROM user grants the TO user the owner authorization which the FROM user has over the specified database users. These rights are revoked from the FROM user. In particular, the TO user is granted the right to delete any specified database user and to alter the user class and other properties of this user.

More Information

Database Administration, Database Users