Possible to Grant gather stats on a table by table basis
19.22
We have schema separation from application users. So a schema owner never logs in, only the app user.
We have very sizeable overnight batch jobs with large variation on data levels and so regularly run into stats issues with plan changes. To mitigate we give users a package call which will gather stats for them and we hardcode the table for them in the proc, they call after any significant data changes. Standard method used by many shops. This works.
Looking for a more scalable permission solution. as we now have a lot of procs in the package.
Without granting exec on dbms_Stats, is there a way to grant permission to gather stats on a given table to a given user.