Database Administration (MOSC)

MOSC Banner

Possible to Grant gather stats on a table by table basis

edited Aug 19, 2024 11:34AM in Database Administration (MOSC) 5 commentsAnswered ✓

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.

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