Revoking Privileges for All Users
Go Up to Revoking User Access
To revoke privileges granted to all users as
PUBLIC. For example, the following statement revokes
UPDATE privileges on the
DEPARTMENTS table for all users:
REVOKE SELECT, INSERT, UPDATE ON DEPARTMENTS FROM PUBLIC;
When this statement is executed, only the table’s owner retains full access privileges to
PUBLICdoes not revoke privileges for stored procedures.
PUBLICcannot be used to strip privileges from users who were granted them as individual users.