Oracle Database - 21C | Create User, Delete User and Grant Permission to User using CDB and PDB

In the following video, we are going to learn on: -

1. How to create user in oracle 21C using container database and using pluggable database
2. How to delete the user
3. How to provide permission to user in CDB and PDB.

Note: Please find the link provided below, on how to install oracle database express edition 21C

--------------------------------------------

1. Command to Change to pluggable database:
alter session set container="PluggableDatabaseName";

2. Command to create user:
2A. Using Pluggable Database: create user "USERNAME" identified by "PASSWORD";
2B. Using Container Database: create user "C#USERNAME"# identified by "PASSWORD";

3. Commands to provide access/privileges

A] GRANT ALL PRIVILEGES TO XXXXX;
B] GRANT CONNECT TO XXXXX;
C] GRANT CONNECT, RESOURCE, DBA TO XXXXX;
D] GRANT CREATE SESSION GRANT ANY PRIVILEGE TO XXXXX;
E] GRANT UNLIMITED TABLESPACE TO XXXXX;

F] GRANT CREATE VIEW, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TRIGGER to XXXXX;
G] GRANT ALTER ANY TABLE to XXXXX;
H] GRANT ALTER ANY PROCEDURE to XXXXX;
I] GRANT ALTER ANY TRIGGER to XXXXX;

J] GRANT DELETE ANY TABLE to XXXXX;
K] GRANT DROP ANY PROCEDURE to XXXXX;
L] GRANT DROP ANY TRIGGER to XXXXX;
M] GRANT DROP ANY VIEW to XXXXX;

4. Command to connect to the user using the windows command prompt
sqlplus "UserName"/"Password"@"IPAddress":"PORT"/"PluggableDatabaseName"

5. To View ConnectionName and PluggableName: -
a] "show con_name"
b] "show pdbs".
Make sure to connect to "system" to access the command "show pdbs"

6. To check all the users, use the command:-
"select * from all_users";

Keywords:

#onlineclass #computerprogramming #online #onlinetutorials #onlineearning #onlinebusiness #onlinegaming #class #classes #free #freeclasses #training #database #oracle #oracledatabasetutorial #oracledatabase #createuser #pluggabledatabase

[manisankarutube]

I have suffered a lot with Oracle 21c Sql Plus connection and user creation, Your Explanation is great, thank you so much.

[kanchanadeviraju]

Even I have got lot of connection issues in oracle 21c b/w Sql Developer and SQL*Plus, This video contains answer for all my questions, thanks so much!!

[indiemery]

thank you so much, i couldnt create the user because of c##, this was very helpful

[avis]

Very informative video!! Thanks. Was facing issues understanding Oracle terminologly from a MySQL background.

[Ahmad_Hamdy_Hamdeen]

Nice explain and thank you for put the code in description box
a lot of thanks ❤

[marcelobeani]

Just want to say thanks man. Really nice video. Save me here. :)

[nickfromsibar]

Thanks, I am a newbie, and I was able to follow.

[qvtdicm]

Excellent Explanation ...sir make video for dropping user

[qvtdicm]

Excellent Explanation...sir kindly make video for how to delete users

[adityamalguri]

bro when i am trying to connect user of pdb then it just wont connect sometime it says that my user doesnt exist but it exist and some time it says about username and password but all i entered is correct . dont know how to resolve this help me

[ranjithparuchuri]

nicely explained, bro. i m getting this error for me ORA-01031: insufficient privileges while granting all privileges to a new user in pdb after connecting to pdb. could you clarify this doubt ??

[karunadhamapurkar]

Tried to login from cmd sqlplus error user is not connected to oracle. Login denied

[princezen]

when I try to do the cmd step it shows ora-12504
if anyone has a solution

[SergieArizandieta]

n well how can i delete a user n his connection?