Table Privileges

By default, only superusers and table owners have privileges to access a table. All other users and roles must have USAGE privileges on the table schema, and be granted one or more of the following privileges on the table itself:

• SELECT: Query tables. SELECT privileges are granted by default to the PUBLIC role.
• INSERT: Insert rows, or and load data into tables with COPY.

  COPY FROM STDIN is allowed for users with INSERT privileges, while COPY FROM file requires admin privileges.

• UPDATE: Update table rows.
• DELETE: Delete table rows.
• REFERENCES: Create foreign key constraints on this table. This privilege must be set on both referencing and referenced tables.
• TRUNCATE: Truncate table contents. Non-owners of tables can also execute the following partition operations on them:
  • DROP_PARTITIONS
  • SWAP_PARTITIONS_BETWEEN_TABLES
  • MOVE_PARTITIONS_TO_TABLE
• ALTER: Modify a table's DDL with ALTER TABLE.
• DROP: Drop a table.

See Also

• GRANT (Table)
• REVOKE (Table)