granting SQL tuning Advisor to a user
Hello,
I am trying to give running STA (SQL tuning Advisor) to a user tst_user and i have the stored proc under sys schema.
SQL> select * from dba_sys_privs where grantee = 'TST_USER' ;
GRANTEE PRIVILEGE ADMIN_OPT
------------------------------ ---------------------------------------- ---------
TST_USER ADVISOR NO
TST_USER CREATE SESSION NO
Log running it as tst_user -
SQL> set serverout on
SQL> sho user
USER is "TST_USER"
SQL> exec sys.CIGNA_STA('1xn0w30cskk5h') ;
GENERAL INFORMATION SECTION
------------------------------------------------------------------------
Tuning Task Name : ST_06_21_2017_12_32_05
Tuning Task Owner :
TST_USER
Workload Type : Single SQL Statement
Scope : COMPREHENSIVE
Time Limit(seconds): 500