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

From Richard Broersma
Subject Re: Identify Login User & Permissions
Date
Msg-id AANLkTi=TLm+mrXMZPoE9qajMr_AbuNs16UaxgLHLin81@mail.gmail.com
Whole thread Raw
In response to Re: Identify Login User & Permissions  (Carlos Mennens <carlos.mennens@gmail.com>)
List pgsql-general
On Tue, Sep 14, 2010 at 1:28 PM, Carlos Mennens
<carlos.mennens@gmail.com> wrote:

> Do you know how I can verify what privileges or permissions 'carlos'
> has granted to him in PostgreSQL?

psql has its own commands.



for example if i was to see the owner of all:

users:
db=> \du

schemas:
db=> \dn

tables/views:
db => \d

other useful commands:
db => \?

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-general by date:

Previous
From: "Jonathan Brinkman"
Date:
Subject: Re: I keep getting "type does not exist" on compile of this SETOF function (list 2 table)
Next
From: Guillaume Lelarge
Date:
Subject: Re: Identify Login User & Permissions