Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

question about creating user in PDB and container databases

Murray SobolJun 14 2021

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??

This post has been answered by Murray Sobol on Jul 4 2022
Jump to Answer
Comments
Post Details
Added on Jun 14 2021
4 comments
2,759 views