Revoking Privileges for All Users

Go Up to Revoking User Access

To revoke privileges granted to all users as PUBLIC, use REVOKE with PUBLIC. For example, the following statement revokes SELECT, INSERT, and 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 DEPARTMENTS.

Important: PUBLIC does not revoke privileges for stored procedures. PUBLIC cannot be used to strip privileges from users who were granted them as individual users.