Re: Analyze Command and Privileges

james.stewart2_at_ccra-adrc.gc.ca (JimS) wrote in message news:<e8ba4080.0309181056.1c6fc350_at_posting.google.com>...
> Hi all,
>
> I need some info from the Oracle gods. I want to implement the
> Analyze table command in a job stream that will be run from an
> automated process not belonging to the DB group.
>
> Question 1 - If I give the "Automated" user id access to the "ANALYZE
> ANY" command, do they have any other privileges that can screw up the
> database.
>
> Question 2 - If the ANALYZE command aborts during execution, can it
> create major damage to the database.
>
>
> Thanks,
>
> Jim

Jim, if the only privileges you give the ID is analyze any and create session then the only other access the ID will have is to object privileges granted to PUBLIC.

What do you mean by major damage to the db? It is unlikely that the failure of an analyze statement or the instance while an analyze was in process would cause any lasting harm to the DB itself. I am not in front of a system where I can run a test showing object statistics, starting an analyze, killing the analyze partway through, and checking the statistics but the analyze operation should be a transaction so I do believe the original statistics would still be in effect.

HTH -- Mark D Powell -- Received on Thu Sep 18 2003 - 20:25:27 CDT