DB2 Version 10.1 for Linux, UNIX, and Windows

Scenario: ExampleHMO using row and column access control - Revoke authority

Alex, as security administrator, is responsible for controlling who can create secure objects. When developers are done creating secure objects, Alex revokes their authority on the database.

Paul, the database developer, is done with development activities. Alex immediately revokes the create authority from Paul:

REVOKE CREATE_SECURE_OBJECT ON DATABASE FROM USER PAUL;

If Paul must create secure objects in the future, he must speak to Alex to have the create authority granted again.