Table-level security

The table permissions are INSERT, UPDATE, DELETE, TRIGGER, REFERENCES, and TRUNCATE. One 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 reference to the table and triggers. Apart from this, one could use a comma-separated list for both tables and roles or even grant permissions on all relations in a schema to a certain role.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset