Oracle in a Nutshell

Name

REVOKE (Object Privileges)

Synopsis

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

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

object_name

Name of the object on which privileges are granted.

username

Name of the user who will be granted the object privilege.

role

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.

Common keywords and clauses: schema.