December 2002
Intermediate to advanced
928 pages
85h 29m
English
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.
Name of the object privilege to be granted. Valid privileges are ALTER, DELETE, EXECUTE, INDEX, INSERT, REFERENCES, SELECT, and UPDATE.
Name of the object on which privileges are granted.
Name of the user who will be granted the object privilege.
Name of a role that will be granted the object privilege.
Specifies that the object privilege be granted to all current and future users.
Common keywords and clauses: schema.