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.