*SELECT* pg_has_role() , has_table_privilege(), has_database_privilege(), has_function_privilege
On Thu, Jul 10, 2008 at 1:15 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > > On Thu, 2008-07-10 at 11:08 -0500, Ismael Almaraz Ezparza wrote: > > Hi there, > > I'm connecting to postgres from java using the postgres driver... > > and I need to get the info about the user that is connected to the DB, > lets say > > for example: name, groups, permisions (select, update, execute)... > > > > Does anyone knows how can I get that info? > > > > Also, if the user is in the group "admin", I need to geat a list of users > and > > the permissions of each... just like pgadmin3 does... > > I suggest you turn on query logging to see how pgadmin3 does it. > > Joshua D. Drake > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- William Leite Araújo Pai 0.6 beta 2.1 "Dizem que agora melhora..."
