You have to grand SELECT permissions to the tables inside of it to the user.
You are not EXECUTING the stored procedure but selecting from it so any
permissions given to the stored procedure itself are not recognized. I think
this should be considered an InterBase bug.

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

----- Original Message -----
From: "Bob" <rcmiszuk@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Thursday, June 13, 2002 7:59 AM
Subject: [IBO] Running stored procedure


> I have a stored procedure that returns multiple lines of output. When I
try
> to execute the sp from a TIB_Query (as SELECT * FROM HREPORT), I get "No
> permission for execute access to PROCEDURE HREPORT". Can someone tell me
how
> to fix this? I am able to go through IBConsole and run the procedure
> directly. I can't figure out how to assign the proper permissions for my
> program to run the SP though.
>
> Also I am not sure if TIB_Query is the proper component to use for the SP.
I
> see TIB_StoredProc, but also see that it is only for SP's that return one
> row, not multiple rows. Is it okay to use TIB_Query?
>
> Thanks for the help.
>
> Bob.
>