Database Administration (MOSC)

MOSC Banner

Regarding 'ANALYZE ANY' system prividege

edited Oct 6, 2016 5:00AM in Database Administration (MOSC) 8 commentsAnswered ✓

Hello,

Due to one requirement, after some heavy loading operations, we need to run 'COMPUTE STATISTICS' on a table which is on a different schema.  According to our application design, we have a central user which controls insert, update, delete from other schemas within the application framework (bunch of schemas/users created within database).  In order to gather the statistics, i need to grant 'analyze any' system privilege to the central application user which will serve our purpose to analyze and compute statistics within application framework but due to nature of 'ANALYZE ANY' command it will expand to other non-application related schemas

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center