Oracle Database 12.1.0.2
Hi,
SQL> CREATE
USER c##a_admin IDENTIFIED BY orcl123; SQL> CREATE ROLE c##role1
CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL; SQL> GRANT
c##role1 TO c##a_admin CONTAINER=ALL; SQL> REVOKE c##role1 FROM
c##a_admin;
When I execute the last query, why does it show error?
SQL> REVOKE c##role1 FROM c##a_admin;
REVOKE c##role1 FROM c##a_admin
*
ERROR at line 1:
ORA-01951: ROLE 'C##ROLE1' not granted to 'C##A_ADMIN'
When we revoke role from common user, should I include container=all?
Regards,
Joe