9.7.8.2 REVOKE ROLE

Purpose

The REVOKE ROLE command revokes the role for a user.

Syntax

REVOKE ROLE { ALL | role1 [, role2, ...] } FROM USER { ALL | user1 [, user2...] }

Usage Notes

• role1 and role2 are the names of roles.

• user1 and user2 are the names of users.

• The ALL argument revokes all roles from the user.

• The FROM USER ALL argument revokes the role from all users.

Examples

Example 9-79 shows how to revoke a role from a user.

Example 9-79 Revoking a Role From a User

DBMCLI> REVOKE ROLE db_monitor FROM USER jdoe