Oracle SQL: the Essential Reference

REVOKE (Object Privileges)

REVOKE {object_priv[,object_priv ...] | ALL [PRIVILEGES]} ON [schema.]object_name FROM {username | role | PUBLIC}

Revokes privileges on a database object from one or more users or roles.

Keywords

object_priv

Specifies the name of the object privilege to be granted. Valid privileges are: ALTER, DELETE, EXECUTE, INDEX, INSERT, REFERENCES, SELECT, and UPDATE.

object_name

Specifies the name of the object on which privileges are granted.

username

Specifies the name of the user who will be granted the object privilege.

role

Specifies the name of a role that will be granted the object privilege.

PUBLIC

Specifies that the object privilege be granted to all current and future users.

Example

Revoke INSERT and UPDATE privileges on scott's emp table from debby:

REVOKE insert,update ON scott.emp FROM debby;