Database Security Products (MOSC)

MOSC Banner

Why Executable privielege on TYPE object to DBSNMP while executing space_advisor using DBMS_SPACE pa

edited Aug 15, 2012 8:37PM in Database Security Products (MOSC) 1 commentAnswered
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.

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