Re: Permissions within a function

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.

Regards,
Thomas Hallgren