Oracle Security in CDBs and PDBs - OCP: Oracle Database 12c Administrator Certified Professional - page 646

This example creates the c##password_timeout common role, which has password
authentication.
SQL> CONNECT sys/system@CONT AS SYSDBA
Connected.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
CDB$ROOT
SQL> CREATE ROLE c##password_timeout IDENTIFIED BY secret CONTAINER=ALL;
Role created.
SQL>
Altering and Dropping a Common Role
This example alters the password for the c##password_timeout common role. After we
alter the role, we'll drop it. We'll then create the role again because we will use it later in
this chapter.
SQL> CONNECT sys/system@CONT AS SYSDBA
Connected.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
CDB$ROOT
SQL> ALTER ROLE c##password_timeout IDENTIFIED BY pwdtimeout CONTAINER=ALL;
Role altered.
SQL>
SQL> DROP ROLE c##password_timeout;
Role dropped.
SQL> CREATE ROLE c##password_timeout IDENTIFIED BY secret CONTAINER=ALL;
Role created.
SQL>