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

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

Hi, Could any one please tell me how to get list of all the permissions on the schema (or any postgresql objects), stored them somewhere before executing stored procedure and then restore them? Thanks, Dipti