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

Thread: DBMS_STATS and privileges

  1. #1
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174

    DBMS_STATS and privileges

    I'm trying to run DBMS_STATS.GATHER_SCHEMA_ STATS from within a stored procedure.

    The user running it has DBA role, but I know that "sometimes" or all the time, privileges through a role doesn't work with stored procedures.

    I've already granted anallyze any and execute on sys.dbms_stats directly to the user.

    But I'm still getting the insufficient privilege error.

    What else am I missing?

  2. #2
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174
    Answered my own question: Metalink NoteID: 203220.1
    In addtion to Analyze Any, Select Any (or the specific tables in the other schema) must be granted.

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