Postgres Pro
Downloads
Home   >   mailing lists

Re: Role information table name - Mailing list pgsql-sql

From Jonathan Katz
Subject Re: Role information table name
Date
Msg-id 7867B27E-E263-4A8A-A897-96B95BC6FE1E@excoventures.com
Whole thread Raw
In response to Role information table name  (Gaurav Tomar <gauravtomar14@gmail.com>)
List pgsql-sql
Tree view


On Jul 8, 2020, at 1:25 PM, Gaurav Tomar <gauravtomar14@gmail.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


Jonathan

pgsql-sql by date:

Previous
From: Gaurav Tomar
Date:
Subject: Role information table name
Next
From: "David G. Johnston"
Date:
Subject: Re: Role information table name