Sai Vatshavai, November 09, 2018 - 3:30 pm UTC
Not sure of Auto stats job is being used in this application. More over i believe auto stats job will do the stats on table level , not on the particular partition or on any dynamically created partition.(please correct me if i am wrong)
even the option which you have suggested, i need to contact DBA to grant the select permissions. Was there any other alternate approach.
November 09, 2018 - 3:46 pm UTC
No, you need to have select privs on the view.
The auto job handles partitions too.