Revoking an object-level privilege (SQL)

Revoke an object-level privilege that has been granted to a user or role to restrict access to a specific object, such as a table, view, procedure, sequence, or dbspace.

Prerequisites

To revoke an object-level privilege, one of the following must be true:

You are the owner of the database object you are revoking privileges for.
You have been granted the privilege and have administrative rights on it.
You have the MANAGE ANY OBJECT PRIVILEGE system privilege.

Task

Connect to the database.

Execute a REVOKE statement similar to the following:

REVOKE privilege-name ON object-name FROM userid;

Results

The privilege is revoked from the specified user or role.

Revoking an object-level privilege (SQL)

Task

See also