Privileges issue
From: CenturionX <darwinbaldrich_at_gmail.com>
Date: Mon, 22 Dec 2008 14:08:06 -0800 (PST)
Message-ID: <2f3f6e57-3cf3-4821-b4b7-e15f42193fe4@l33g2000pri.googlegroups.com>
Date: Mon, 22 Dec 2008 14:08:06 -0800 (PST)
Message-ID: <2f3f6e57-3cf3-4821-b4b7-e15f42193fe4@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. Received on Mon Dec 22 2008 - 16:08:06 CST