Re: Role information table name

From: Jonathan Katz <jonathan(dot)katz(at)excoventures(dot)com>
To: Gaurav Tomar <gauravtomar14(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Role information table name
Date: 2020-07-08 17:44:55
Message-ID: 7867B27E-E263-4A8A-A897-96B95BC6FE1E@excoventures.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> On Jul 8, 2020, at 1:25 PM, Gaurav Tomar <gauravtomar14(at)gmail(dot)com> wrote:
>
> Simple question -- in which table postgres store the role privilege information.
>
> CREATE ROLE postgres WITH
> LOGIN
> SUPERUSER
> INHERIT
> CREATEDB
> CREATEROLE
> REPLICATION;
>
> in which table I can find the above information.

pg_catalog.pg_authid

https://www.postgresql.org/docs/current/catalog-pg-authid.html <https://www.postgresql.org/docs/current/catalog-pg-authid.html>

Jonathan

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2020-07-08 17:46:22 Re: Role information table name
Previous Message Gaurav Tomar 2020-07-08 17:25:53 Role information table name