Hi Vijay,
Thanks for all the replies! and yes, your suggestion worked!!
However, I had opened an SR with Oracle and the following is part of it...

"
Starting with 10.2.0.4, password protected roles are not enabled when granted, as this was considered a security hole. t. You'll need to do an ALTER SESSION
SET ROLE to enable it.
"
and I said: "I dont want to do "alter session" everytime. What is the "global" solution?


29-SEP-09 18:03:45 GMT

Perhaps a logom trigger to do the alter? "

They seem to be side-lined with too many complexities over at Oracle

Again, many thanks for your excellent inputs: I learnt something today...

Regards,
Suhas