Thread: How to list all the privileges a user has?

My apologies for all these questions.  I hope this will be the last
one for a while.

I guess the subject line says it all: how does one list all the
privileges a given user has?

Thanks!

kj

I'm aware of functions like has_table_privilege(), etc., but they
don't do what I want.

> My apologies for all these questions.  I hope this will be the last
> one for a while.
> I guess the subject line says it all: how does one list all the
> privileges a given user has?

# select relname, array_to_string(relacl,',') as acl from pg_class
where array_to_string(relacl,',') ~ 'givenuser/';

Thought there was a thread a short while ago, but couldn't find it. String
functions can be used to manipulate the acl string.

If it's changed to
      ~'/givenuser'
you will get the list of privs the user gave to others.



Regards,

Ben K.
Developer
http://benix.tamu.edu