HI,

> >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
> >assumes.
>
>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?

well that's possible for part of the problem. but I am not sure I can
create a view that only displays rows which "belong" to the current user
(one column will be the user id). which is what I am trying to do with the
SP's.