SQL Performance (MOSC)

MOSC Banner

SQL Tuning Advisor - Needed Privileges for Non-Admin-User

edited Jan 27, 2020 8:44AM in SQL Performance (MOSC) 3 commentsAnswered

Hello,

for our application team, i created a non-dba-user, who has special privileges to make some minor administration tasks as creating awr reports, monitoring user sessions etc..

This user now should receive the privileges to run a sql tuning advisor task.

In nearly all documentation you can read, that admin-privileges are needed for running a sql tuning advisor task. I'm sure, that the non-admin-user does not need the full dba role, so does somebody know, which are the dba-privileges the user need?

Best regards

Eike

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