I was able to create a user in my Portal pluggable database (PORTALPDB); I used this SQL:
Enter user-name: conn / as sysdba
Enter password:
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> alter session set container = portalpdb;
I then had to open the database; I used this SQLl:
SQL> alter database open;
Database altered.
SQL> create user Portal2021 identified by sql container = current;
User created.
SQL> GRANT CREATE SESSION, GRANT ANY PRIVILEGE TO Portal2021
2 /
Grant succeeded.
SQL> GRANT CREATE TABLE TO Portal2021
2 /
My PDB database is Portalpdb and my container database is Portal.
How do i create a user in my container database??