The key to the whole deal, as it turns out, being that the ANALYZE
ANY privilege must be granted explicitly in order to work in a stored
procedure. I tested this with a procedure for analyzing a table and
not even sys had sufficient privileges. But once I granted 'analyze
any' to a user they w
[EMAIL PROTECTED] wrote:
> I have two schemas: schema1 and schema2. I need to analyze
> schema1.mytable from a stored procedure owned by schema2. Schema1 has
> granted ALL on mytable to Schema2.
>From the Administrator's Guide: "To analyze a table, cluster, or index, you
must own the table,
Did you grant the privileges directly or through a role?
You need to grant them directly in order to have access to them in PL/SQL.
Jay Miller
x48355
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
This problem