I don't think you can do it. You have to parse the string you got from
pg_namespace to get the current user's permissions.
On Thu, Apr 1, 2010 at 11:09 AM, dipti shah shahdipti1...@gmail.com wrote:
Hi,
I ran below command to list out all privileges of objects if mydb schema.
Actually, I
Hi,
I ran below command to list out all privileges of objects if mydb schema.
Actually, I want to know what are the permissions user1 has on mydb
schema. Could you please tell me how to do this?
mydb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn where
pc.relnamespace=pn.oid
Hi,
I ran below command to list out all privileges of objects if mydb schema.
Actually, I want to know what are the permissions user1 has on mydb
schema. Could you please tell me how to do this?
mydb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn where
pc.relnamespace=pn.oid