agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Stephen Frost <sfrost@snowman.net>
To: Gaurav Tomar <gauravtomar14@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Role information table name
Date: Wed, 8 Jul 2020 13:54:02 -0400
Message-ID: <20200708175402.GL3125@tamriel.snowman.net> (raw)
In-Reply-To: <CAByYU3TM5JOtSirYwXWxeuA_g_60d796Z7O0D+EDVoH9ownTjQ@mail.gmail.com>
References: <CAByYU3TM5JOtSirYwXWxeuA_g_60d796Z7O0D+EDVoH9ownTjQ@mail.gmail.com>

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

view thread (4+ messages)

Message-ID: <20200708175402.GL3125@tamriel.snowman.net>
Permalink:  ../20200708175402.GL3125@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20200708175402.GL3125@tamriel.snowman.net

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sfrost@snowman.net, gauravtomar14@gmail.com
  Subject: Re: Role information table name
  In-Reply-To: <20200708175402.GL3125@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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