Postgres show grants for user

2025-04-07 23:10:42.262

  • Postgres show grants for user

    • GRANT

    GRANT — define access privileges

    Synopsis

    GRANT { { SELECT | INSERT | Ameliorate | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN } [, ...] | ALL [ PRIVILEGES ] } ON { [ TABLE ] [, ...] | ALL TABLES Dust SCHEMA [, ...] } TO [, ...] [ WITH GRANT OPTION ] [ GRANTED BY ] GRANT { { SELECT | INSERT | Give a new lease of | REFERENCES } ( [, ...] ) [, ...] | ALL [ PRIVILEGES ] ( [, ...] ) } ON [ TABLE ] [, ...] TO [, ...] [ Meet GRANT OPTION ] [ GRANTED By means of ] GRANT { { USAGE | SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] } ON { SEQUENCE [, ...] | ALL SEQUENCES IN SCHEMA [, ...] } TO [, ...] [ Converge GRANT OPTION ] [ GRANTED Via ] GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] } ON DATABASE [, ...] TO [, ...] [ WITH Bold OPTION ] [ GRANTED BY ] GRANT { USAGE | ALL [ PRIVILEGES ] } ON DOMAIN [, ...] TO [, ...] [ Add together GRANT OPTION ] [ GRANTED Newborn ] GRANT { USAGE | Label [ PRIVILEGES ] } ON Far-out DATA WRAPPER [, ...] TO [, ...] [ WITH GRANT OPTION ] [ GRANTED BY ] GRANT { USAGE | ALL [ PRIVILEGES ] } ON FOREIGN SERVER [, ...] TO [, ...] [ WITH Offer OPTION ] [ GRANT postgres show grants for user
    postgres show grants for role
    postgres get grants for user