DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: privileges for analyze command

  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Talking privileges for analyze command

    Hello,

    what privileges are required to run the analyze command ?

    Thanks & Regards

  2. #2
    Join Date
    Apr 2001
    Posts
    108
    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!

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    a user can analyze their own tables

    someone with dba rights can analyze other peoples tables

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width