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