SQL> CONN SYS/SYS@ORCLPDB AS SYSDBA
Connected.
SQL> ALTER USER HR IDENTIFIED BY HR;
User altered.
SQL> ALTER USER HR IDENTIFIED BY HR ACCOUNT UNLOCK;
User altered.
SQL> GRANT DBA TO HR;
Grant succeeded.
SQL> CONN HR/HR@ORCLPDB
Connected.
---------------------------------
STARTUP
ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE;
Tags:
Database tips & tricks