Learning PostgreSQL 11 - Third Edition

Object-level security

The database objects, such as tables, views, sequences, domain, data types, and functions can be secured by granting and revoking permissions. The permissions are different for each objects. For example, the sequence has USAGE permission, and the function has EXECUTE permission.

The table permissions are INSERT, UPDATE, DELETE, TRIGGER, REFERENCES, and TRUNCATE. You can also use the keyword ALL to grant all privileges at once, as follows:

GRANT ALL ON <table_name> TO <role>;

REFERENCES and TRIGGER permissions allow the creation of foreign key references to the table and triggers. Apart from this, you could use a comma-separated list for both tables and roles, or even grant permissions on all relations in a schema to ...