Revoking All Privileges
From InterBase
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
ALL does not revoke
EXECUTE
privilege.