Users who create a schema with CREATE SCHEMA (without an AUTHORIZATION clause), or users specified in the AUTHORIZATION clause, own the schema in question. As the owner of a schema, users have all the table privileges for objects in that schema. In addition, they are allowed to grant table privileges for the schema to other users.
Selection of rows (SELECT)
The table privilege SELECT for a specific tables entitles users to select rows in that table and to define a view of the table with CREATE VIEW. The table privilege SELECT remains valid if columns are added after the privilege was granted.
Insertion of rows (INSERT)
The table privilege INSERT for a specific table entitles users to insert rows in that table. Before rows can be inserted, the user must have the table privilege SELECT on the tables named in the query expression of the INSERT or MERGE statement. The table privilege INSERT remains valid if columns are added after the privilege was granted.
Deletion of rows (DELETE)
The table privilege DELETE for a specific table entitles users to delete rows in that table. Before rows can be deleted, the user must have the table privilege SELECT on the tables named in the query expression of the DELETE statement. The table privilege DELETE remains valid if columns are added after the privilege was granted.
Updating of values in rows (UPDATE)
The table privilege UPDATE for a specific table entitles users to update the values in specific columns in the tables rows. Before rows can be updated, the user must have the table privilege SELECT on the tables named in the query expression of the UPDATE or MERGE statement. If no columns are specified in the table privilege UPDATE, the privilege applies to the whole of the table, including any columns added to it after the privilege was granted.
Specification of columns in integrity constraints (REFERENCES)
The table privilege REFERENCES for selected columns in a specific table entitles users to use these columns when defining integrity constraints. If no columns are specified in the table privilege, it applies to the whole of the table, including all the columns added after the privilege was granted.
All privileges (ALL PRIVILEGES)
ALL PRIVILEGES for a specific table gives grantees all the privileges that the grantor is entitled to grant for that table.