title: SQL: Realm Violation for GRANT on ALTER SESSION
body: <p>New to realms. I have installed an Oracle Database and created a user (USER1).  Trying to grant him permissions, i get this error. </p>
  
  <pre><code>SQL&gt; GRANT ALTER SESSION TO USER1;
  GRANT ALTER SESSION TO USER1
  *
  ERROR at line 1:
  ORA-47410: Realm violation for GRANT on ALTER SESSION
  </code></pre>
  
  <p>When i try the suggested solution i get same.</p>
  
  <pre><code>SQL&gt; BEGIN
      DVSYS.DBMS_MACADM.CREATE_REALM(
    2    3      realm_name =&gt; 'Test_Realm',
    4      description =&gt; 'Test',
    5      enabled =&gt; DBMS_MACUTL.G_YES,
    6      audit_options =&gt; 0);
    7      END;
    8      /
  
  PL/SQL procedure successfully completed.
  
  
  SQL&gt; BEGIN
      DVSYS.DBMS_MACADM.ADD_OBJECT_TO_REALM(
    2    3      realm_name =&gt; 'Test_Realm',
    4      object_owner =&gt; 'RAYMONDO',
    5      object_name =&gt; 'RAYMONDO',
    6      object_type =&gt; 'ROLE');
    7      END;
    8
  /  9
  
  PL/SQL procedure successfully completed.
  
  SQL&gt; BEGIN
            DVSYS.DBMS_MACADM.ADD_AUTH_TO_REALM(
    2    3            REALM_NAME =&gt; 'Test_Realm',
    4            GRANTEE =&gt; 'RAYMONDO',
    5            AUTH_OPTIONS =&gt; DVSYS.DBMS_MACUTL.G_REALM_AUTH_OWNER);
    6          END;
    7      /
  
  PL/SQL procedure successfully completed.
  
  SQL&gt; GRANT ALTER SESSION TO RAYMONDO;
  GRANT ALTER SESSION TO RAYMONDO
  *
  ERROR at line 1:
  ORA-47410: Realm violation for GRANT on ALTER SESSION
  </code></pre>
  
  <p>So am not sure what is needed</p>