Why Executable privielege on TYPE object to DBSNMP while executing space_advisor using DBMS_SPACE pa
Hello Experts,
Please have a look at following test case and comment on "why Executable privielege on TYPE object to DBSNMP user, while executing space_advisor using DBMS_SPACE, is granted"?
This new behavior is observed only in 11.2.0.3. and for my customer, which is a bank, any user having system privilege with GRANTABLE/ADMIN option is an audit violation .
Test Case:
=========
1. Disabled auto space advisor task
SQL> select client_name,status from Dba_Autotask_Client;
CLIENT_NAME STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection DISABLED
auto space advisor DISABLED
sql tuning advisor ENABLED
SQL>
2. Identified the object with grantable option for the user DBSNMP.
Please have a look at following test case and comment on "why Executable privielege on TYPE object to DBSNMP user, while executing space_advisor using DBMS_SPACE, is granted"?
This new behavior is observed only in 11.2.0.3. and for my customer, which is a bank, any user having system privilege with GRANTABLE/ADMIN option is an audit violation .
Test Case:
=========
1. Disabled auto space advisor task
SQL> select client_name,status from Dba_Autotask_Client;
CLIENT_NAME STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection DISABLED
auto space advisor DISABLED
sql tuning advisor ENABLED
SQL>
2. Identified the object with grantable option for the user DBSNMP.
0