Revoking All Privileges

Go Up to Revoking User Access

The ALL privilege combines the SELECT, DELETE, INSERT, and UPDATE privileges for a table in a single expression. It is a shorthand way to remove all SQL table access privileges from a user or procedure. For example, the following statement revokes all access privileges for the DEPARTMENTS table for a user, SUSAN:

REVOKE ALL ON DEPARTMENTS FROM SUSAN;

Even if a user does not have all access privileges for a table, ALL can still be used. Using ALL in this manner is helpful when a current user’s access rights are unknown.

Note: ALL does not revoke EXECUTE privilege.