Rights to stored procedures are only when it is used via EXECUTE PROCEDURE,
not when it is being selected from.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Bert Neef" <bert@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, July 03, 2002 1:08 PM
Subject: [IBO] TIB_Cursor, a stored procedure and rights.


> Hi All,
>
> I have a very annoying problem, 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 tried again. doesn't work.
> I get an error about not having select rights on the table, which the
> user/role doesn't have. but the stored procedure does have.
>
> Am I doing something wrong or is this simply not possible? I am using
> firebird 1.0 with IBO 4.2Hf under delphi 5.0 Prof.
>
> Any help/suggestions are greatly appreciated.
>
> Bert
>