Subject Re: [IBO] TIB_Cursor, a stored procedure and rights.
Author Svein Erling Tysvær
Bert wrote:
>I have a TIB_Cursor which does a select on a stored procedure. this works
>perfectly when I execute it as sysdba. Well I don't want the regular user to
>have access to the table so I granted the select right on that table to the
>stored procedure, the execute right on the procedure to the role the user

and later

>so there's no way to get a selection from a table without the user having
>sufficient rights to that table?

and Jason replied:
>Unfortunately this appears to be a limitation of InterBase.

Surely it must be possible to create a view, give the role rights to that
view and let the stored procedure operate upon the view?