Re: Privileges issue

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 23 Dec 2008 08:26:48 +0100
Message-ID: <495092b7$0$7165$426a74cc@news.free.fr>

"CenturionX" <darwinbaldrich_at_gmail.com> a crit dans le message de news: 2f3f6e57-3cf3-4821-b4b7-e15f42193fe4_at_l33g2000pri.googlegroups.com... Hello everybody,

Im 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 Im 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 Received on Tue Dec 23 2008 - 01:26:48 CST

Original text of this message