Database Security Products (MOSC)

MOSC Banner

Password authorized role not being enabled by default

edited Jan 4, 2010 3:19AM in Database Security Products (MOSC) 5 commentsAnswered
Hi

 I'm having a problem (in an 11.1.0.7 db) where a role with a password has been assigned to a user (as a default role), but the user doesn't appear to have any access to the role objects - If i disable the password authentication on the role, the user can access the role objects

As far as I can tell from the documentation, the password authorisation setting should be over-ridden if the role is set as a default role, but this doesn't seem to be the case  - is there something else I need to be doing ?

any help greatly appreciated.....

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