Re: [GENERAL] Get the list of permissions/privileges on schema

Thanks Ashesh, I ran below command and it is listing all privileges of objects under 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.re

Re: [GENERAL] Get the list of permissions/privileges on schema

Okay..then could you please suggest me what could be the correct way? So far I have done following to meet my requirements: * I want users to use only stored procedures to create, alter, delete tables in mydb schema*. ==> For this I have *revoked all permissions from mydb *schema and stored procedu

Re: [GENERAL] Get the list of permissions/privileges on schema

dipti shah wrote: Thanks a lot guys but I am not looking for security definer function. I know it. My requirements are very complicated and I have to nailed down the stuffs by storing schema permissions somewhere, execute my store procedure, and restored the stored schema permissions. Like this

Re: [GENERAL] Get the list of permissions/privileges on schema

Thanks a lot guys but I am not looking for security definer function. I know it. My requirements are very complicated and I have to nailed down the stuffs by storing schema permissions somewhere, execute my store procedure, and restored the stored schema permissions. Like this I would make sure tha

Re: [GENERAL] Get the list of permissions/privileges on schema

On Thu, Mar 25, 2010 at 2:54 PM, Sergey Konoplev wrote: > On 25 March 2010 12:14, Ashesh Vashi > wrote: > > You should look into the pg_class table : relacl attribute for the > > permissions on any object. > > Is it correct to set it directly? > Of course not... This is just way to fetch the li

Re: [GENERAL] Get the list of permissions/privileges on schema

On 25 March 2010 12:14, Ashesh Vashi wrote: > You should look into the pg_class table : relacl attribute for the > permissions on any object. Is it correct to set it directly? > On Thu, Mar 25, 2010 at 2:37 PM, dipti shah wrote: >> Could any one please tell me how to get list of all the permiss

Re: [GENERAL] Get the list of permissions/privileges on schema

You should look into the pg_class table : relacl attribute for the permissions on any object. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On Thu, Mar 25, 2010 at 2:37 PM, dipti shah wrote: > Hi, > > Could any one please tell me