1 Reply Latest reply: Oct 4, 2012 7:52 AM by Leo Lakota RSS

    DEFAULT ROLE FOR USER

    Leo Lakota
      I swich to Oracle11g express and create user


      CREATE USER LEO
      IDENTIFIED BY xy
      DEFAULT TABLESPACE USERS
      TEMPORARY TABLESPACE TEMP
      PROFILE DEFAULT
      ACCOUNT UNLOCK;
      -- 3 Roles for LEO
      GRANT AUTHENTICATEDUSER TO LEO;
      GRANT CONNECT TO LEO;
      GRANT FER_ADMIN TO LEO WITH ADMIN OPTION;
      ALTER USER LEO DEFAULT ROLE FER_ADMIN;
      -- 1 System Privilege for LEO
      GRANT CREATE SESSION TO LEO;
      -- 1 Tablespace Quota for LEO
      ALTER USER LEO QUOTA UNLIMITED ON USERS;

      and after login i check
      select * from SESSION_ROLES
      and i have none role
      if I set role all works fine.
      Why I doesn't have DEFAULT ROLE after login.

      Pleas for help .