agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

Role information table name
4+ messages / 4 participants
[nested] [flat]

* Role information table name
@ 2020-07-08 17:25 Gaurav Tomar <gauravtomar14@gmail.com>
  2020-07-08 17:44 ` Re: Role information table name Jonathan Katz <jonathan.katz@excoventures.com>
  2020-07-08 17:46 ` Re: Role information table name David G. Johnston <david.g.johnston@gmail.com>
  2020-07-08 17:54 ` Re: Role information table name Stephen Frost <sfrost@snowman.net>
  0 siblings, 3 replies; 4+ messages in thread

From: Gaurav Tomar @ 2020-07-08 17:25 UTC (permalink / raw)
  To: pgsql-sql

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.

Regards,

Gaurav

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Role information table name
  2020-07-08 17:25 Role information table name Gaurav Tomar <gauravtomar14@gmail.com>
@ 2020-07-08 17:44 ` Jonathan Katz <jonathan.katz@excoventures.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Jonathan Katz @ 2020-07-08 17:44 UTC (permalink / raw)
  To: Gaurav Tomar <gauravtomar14@gmail.com>; +Cc: pgsql-sql



> 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

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

Jonathan

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Role information table name
  2020-07-08 17:25 Role information table name Gaurav Tomar <gauravtomar14@gmail.com>
@ 2020-07-08 17:46 ` David G. Johnston <david.g.johnston@gmail.com>
  2 siblings, 0 replies; 4+ messages in thread

From: David G. Johnston @ 2020-07-08 17:46 UTC (permalink / raw)
  To: Gaurav Tomar <gauravtomar14@gmail.com>; +Cc: pgsql-sql

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

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

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

David J.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Role information table name
  2020-07-08 17:25 Role information table name Gaurav Tomar <gauravtomar14@gmail.com>
@ 2020-07-08 17:54 ` Stephen Frost <sfrost@snowman.net>
  2 siblings, 0 replies; 4+ messages in thread

From: Stephen Frost @ 2020-07-08 17:54 UTC (permalink / raw)
  To: Gaurav Tomar <gauravtomar14@gmail.com>; +Cc: pgsql-sql

Greetings,

* 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.

While this is in pg_authid, if that's all the info you want to find out,
you should probably be getting it from pg_roles (which is a view over
pg_authid), since you need to be GRANT'd access to pg_authid unless
you're a superuser.

Thanks,

Stephen

Attachments:

  [application/pgp-signature] signature.asc (818B, ../../20200708175402.GL3125@tamriel.snowman.net/2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2020-07-08 17:54 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-07-08 17:25 Role information table name Gaurav Tomar <gauravtomar14@gmail.com>
2020-07-08 17:44 ` Jonathan Katz <jonathan.katz@excoventures.com>
2020-07-08 17:46 ` David G. Johnston <david.g.johnston@gmail.com>
2020-07-08 17:54 ` Stephen Frost <sfrost@snowman.net>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox