By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

Running function as superuser

P: 2
How I can run a function written in plpgsql as superuser when I'm logged into the database as normal user with a restrict access to tables?
Sep 17 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 700
1) you can set your role to admin and run a function (if you have enough strong privileges)
2) you can create this function from admin account with SECURE DEFINER option. Everybody would run this functions with admin rights.
Sep 17 '08 #2

P: 2
Problem solved with the security definer. Thanks a lot rski!
Sep 17 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.