-
privileges for analyze command
Hello,
what privileges are required to run the analyze command ?
Thanks & Regards
-
The schema object to be analyzed must be local, and it must be in your own schema or you must have the ANALYZE ANY system privilege.
If you want to list chained rows of a table or cluster into a list table, the list table must be in your own schema, or you must have INSERT privilege on the list table, or you must have INSERT ANY TABLE system privilege.
If you want to validate a partitioned table, you must have INSERT privilege on the table into which you list analyzed rowids, or you must have INSERT ANY TABLE system privilege
Eric Hanson
There are 10 types of people in the world:
Those who understand binary and those who don't!
-
a user can analyze their own tables
someone with dba rights can analyze other peoples tables
-
Originally posted by davey23uk
a user can analyze their own tables
someone with dba rights can analyze other peoples tables
This changed in 9.2 a bit. I tried (as user A having the DBA role) to analyze the (tables and) indexes of user B using DBMS_STATS. ANALYZE ANY was not enough. SELECT ANY TABLE is now also needed in 9.2.
Check 203220.1 for more information.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|