Regarding 'ANALYZE ANY' system prividege
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