11g default role authenticated by password change from 10g
Default roles in pre-11g databases are enabled whether they authenticate with a password or not. In 11g (11.1.0.7), use of "set role..." is required if password authentication of a role is used. I didn't find this in new features doc. Is this as designed?
0