4 Replies Latest reply on Oct 23, 2019 9:11 AM by Praveen Ch-Oracle

    Revoke role from a user (testuser) from container database

    3405241

      Unable to revoke role from user in container database. Please suggest

       

      SQL> select username, con_id from cdb_users where username ='I601899';

       

      USERNAME   CON_ID

      -----------------

      edr899      1

       

      SQL> revoke toolrole from edr899;

      revoke toolrole from edr899

      *

      ERROR at line 1:

      ORA-01951: ROLE 'toolrole ' not granted to 'edr899'

       

      SQL> select * from dba_role_privs where GRANTEE='edr899' and GRANTED_ROLE='toolrole ';

       

       

      GRANTEE      GRANTED_ROLE   ADM DEL DEF COM

      -------------- ---         --- --- ---

      edr899     toolrole  NO  NO  YES YES