Re: Role information table name

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Gaurav Tomar <gauravtomar14(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Role information table name
Date: 2020-07-08 17:46:22
Message-ID: CAKFQuwaN1BkXm4o0JQGpgLb7tARky5=dB67nLmkJcQmpM8WCyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wednesday, July 8, 2020, 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.
>

https://www.postgresql.org/docs/12/catalogs-overview.html

https://www.postgresql.org/docs/12/catalog-pg-authid.html

David J.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephen Frost 2020-07-08 17:54:02 Re: Role information table name
Previous Message Jonathan Katz 2020-07-08 17:44:55 Re: Role information table name