title: Grants by role changed in Oracle 11g?
body: <p>I tried to grant <code>CONNECT</code> to a user through a role:</p>
  
  <pre><code>CREATE ROLE my_role IDENTIFIED BY "passwd";
  GRANT CONNECT TO my_role;
  
  CREATE USER my_user IDENTIFIED BY "passwd";
  GRANT my_role TO my_user;
  </code></pre>
  
  <p>When I try this in <strong>10g</strong> it works fine, while in <strong>11g</strong> login is rejected:</p>
  
  <p><a href="http://ora-01045.ora-code.com/" rel="nofollow noreferrer"><code>ORA-01045:</code></a><code>user MY_USER lacks CREATE SESSION privilege; logon denied</code></p>
  
  <p>Granting <code>CREATE SESSION</code> to the role does not make a difference.<br/>
  I can only login after directly granting <code>CONNECT</code> (or <code>CREATE SESSION</code>) to the user.</p>
  
  <p>Has Oracle changed this behavior or am I doing something wrong?</p>