9.7.5.2 GRANT ROLE

Purpose

The GRANT ROLE command sets the role for a user.

Syntax

GRANT ROLE { ALL | role1 [, role2, ...] } TO USER { ALL | user1 [, user2...] }

Usage Notes

• role is the name of the role.

• The ALL argument grants all roles to the user.

• The TO USER ALL argument grants the role to all users.

Example 9-58 Granting a Role to a User

This example shows how to grant a role to a user.

DBMCLI> GRANT ROLE dbmonitor TO USER agarcia