On 25 March 2010 12:14, Ashesh Vashi <ashesh.vashi@xxxxxxxxxxxxxxxx> 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 <shahdipti1980@xxxxxxxxx> wrote: >> 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? May be you are looking for something like SECURITY DEFINER option? http://www.postgresql.org/docs/8.4/interactive/sql-createfunction.html -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com / Linkedin: http://ru.linkedin.com/in/grayhemp / JID/GTalk: gray.ru@xxxxxxxxx / Skype: gray-hemp / ICQ: 29353802 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
