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,

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

This message: [ Message body ]
Next message: Michel Cadot: "Re: best way to simulate a lost connection?"
Previous message: croora: "restore"
In reply to: CenturionX: "Privileges issue"
Next in thread: CenturionX: "Re: Privileges issue"
Reply: CenturionX: "Re: Privileges issue"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message