Oracle Database Discussions

Hi!

In Oracle 10g the statements bellow works perfectly. After execute them, I can connect with user MY_USER.

CREATE ROLE MY_ROLE IDENTIFIED BY MEGA;
GRANT CONNECT TO MY_ROLE;

CREATE USER MY_USER IDENTIFIED BY MEGA;
GRANT MY_ROLE TO MY_USER;


Although, in 11g I get the "ORA-01045: user MY_USER lacks CREATE SESSION privilege; logon denied" in the same situation. It only works if I grant "CREATE SESSION" directly to MY_USER.

Is there anyway to grant the privilege to my users through roles in 11g?

Thanks!