Re: Identify Login User & Permissions - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Identify Login User & Permissions
Date
Msg-id 4C8FE5A4.7020101@lelarge.info
Whole thread Raw
In response to Re: Identify Login User & Permissions  (Carlos Mennens <carlos.mennens@gmail.com>)
List pgsql-general
Le 14/09/2010 22:28, Carlos Mennens a écrit :
> On Tue, Sep 14, 2010 at 4:23 PM, Guillaume Lelarge
> <guillaume@lelarge.info> wrote:
>> SELECT current_user;
>
> Thanks. That worked well:
>
> postgres=# SELECT current_user;
>  current_user
> --------------
>  carlos
> (1 row)
>
> Do you know how I can verify what privileges or permissions 'carlos'
> has granted to him in PostgreSQL?
>

You need to check many things on the catalogs to know that. You won't
find a single command to do that.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Identify Login User & Permissions
Next
From: "tamanna madaan"
Date:
Subject: workaround steps for autovaccum problem