Password authenticated role are not enable in 11g

Recently I upgraded a 10.2.0.4 database to 11.2.0.3 and the default role mechanism wasn’t working.

Queries were failing for endusers that had worked before….

Come to find out Oracle changed the way Default Roles work, the following is a quote from My Oracle Support Doc- What Roles Can Be Set as Default for a User? [ID 745407.1]

“The DEFAULT clause in the:

alter user <username> default roles <role list>;

specifies the roles granted by default to the user at logon. This clause can contain only roles that have been granted directly to the user with a GRANT statement, or roles created by the user with the CREATE ROLE privilege.