Granting Privileges to All Users

Go Up to Granting Privileges to Multiple Users

To assign the same access privileges for a table to all users, use the PUBLIC keyword rather than listing users individually in the GRANT statement.

The following statement grants SELECT, INSERT, and UPDATE privileges on the DEPARTMENTS table to all users:

GRANT SELECT, INSERT, UPDATE ON DEPARTMENTS TO PUBLIC;

Important: PUBLIC grants privileges only to users, not to stored procedures, triggers, roles, or views. Privileges granted to users with PUBLIC can only be revoked from PUBLIC.