Privileges issue

Hello everybody,

I’m having trouble trying to run a procedure.
I have a query that retrieves information from a table X.
I run the query and it works fine.
When I put the same query in a cursor into a procedure it generates an
error
PL/SQL: ORA-01031: insufficient privileges
The user I’m using is created in one schema and the table I want to
query is in another one.
I took care of put the schema prefix for the table.
Please give a hand on this.

Thanks.

"CenturionX" a écrit dans le message de
2f3f6e57-3cf3-4821-b4b7-e15f42193fe4.TakeThisOut@l33g2000pri.googlegroups.com...
Hello everybody,

I’m having trouble trying to run a procedure.
I have a query that retrieves information from a table X.
I run the query and it works fine.
When I put the same query in a cursor into a procedure it generates an
error
PL/SQL: ORA-01031: insufficient privileges
The user I’m using is created in one schema and the table I want to
query is in another one.
I took care of put the schema prefix for the table.
Please give a hand on this.

Thanks.

--------------------------------------------

http://asktom.oracle.com/tkyte/Misc/RolesAndProcedures.html

Regards
Michel