Re: [HACKERS] Permissions within a function

[Andrew Dunstan]

Thomas Hallgren wrote:
vamsi,
Why dont you create a view on the table and access the view rather
than the table. I guess this would resolve the issue.
What ever select statement you want to have on the table you can make
it a select statement of the view. thus restricting the access to the
main table.
Looking forward to hear from you.
I don't think a view would help much. I want to completely prevent the 
user from viewing or changing any data stored in the table. Using a 
view would just move the problem. Now the user must have select access 
to the view in order to call the function and that is just as bad.


Thomas,
I'm not sure if I understand exactly what you want, but would a 
"security definer" function help?

cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend