Hi friends,
I have a procedure owned by user1. A global temporary table and a package are also a part of the procedure.
I wanted to give user2 , privilege to execute this procedure.
So, i granted execute privilege on both package and procedure and also, select, delete etc on the global temp table.
Still, when I try to execute the procedure as user2, it comes out with the message that "ORA-00942: table or view does not exist".
What else is needed to be done to execute the procedure as user2?
I am running 8.1.6 on compaq tru-64
Thanks
manjunath