Privileges issue

From: CenturionX <>
Date: Mon, 22 Dec 2008 14:08:06 -0800 (PST)
Message-ID: <>

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

Original text of this message