Re: Permissions within a function

Thomas Hallgren <thhal@mailblocks.com> writes:
> 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.

Just out of curiosity, why use a table at all, if you intend to forbid
all SQL-level access to it?  Seems to me that what you want is either
a table (C array) hard-wired in the code, or a configuration file.
        regards, tom lane