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
This problem is probably related to trying to do something from within a
stored procedure that can't be done, however I can't find anything in the
docs that say that. I've opened an iTar but the response has been
WORTHLESS, and that goofy person keeps asking me in six different ways what
grants a