Database Administration (MOSC)

MOSC Banner

What is the impact of Removing DBA_ROLES privilage from SELECT_CATALOG_ROLE and CTXSYS

edited Jun 29, 2015 10:01AM in Database Administration (MOSC) 2 commentsAnswered

KPMG auditors were pointed out the DBA_ROLES privileges granted to SELECT_CATALOG_ROLE and CTXSYS have to be removed from production 10g databases. So Id like to know the impact of removing these privilege? 

KPMG comment :

Prevent access to DBA_ROLES from unnecessary usersMediumIt was observed that the following users have given access to the DBA_ROLES


"CTXSYS"
"SELECT_CATALOG_ROLE"
DBA_ROLES lists all roles that exist in the database. It should only be accessed by the SYS and the database administratorAllowing access to DBA ROLES table to an unnecessary user may enable that user to alter the DBA_ROLES table, which may result in privilege escalation or system instability

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