ALTER DEFAULT PRIVILEGES

alter_default_priv

abbr_grant_or_revoke

ALTER DEFAULT PRIVILEGES - 图2

a_grant_table

a_grant_seq

ALTER DEFAULT PRIVILEGES - 图4

a_grant_func

a_grant_type

a_grant_schema

ALTER DEFAULT PRIVILEGES - 图7

a_revoke_table

a_revoke_seq

ALTER DEFAULT PRIVILEGES - 图9

a_revoke_func

a_revoke_type

ALTER DEFAULT PRIVILEGES - 图11

a_revoke_schema

grant_table_priv

grant_seq_priv

ALTER DEFAULT PRIVILEGES - 图14

grant_role_spec

defines the privileges for objects created in future. It does not affect objects that are already created.

Users can change default privileges only for objects that are created by them or by roles that they are a member of.

  • Grant SELECT privilege to all tables that are created in schema marketing to all users.
  • Revoke INSERT privilege on all tables from user john.