Oracle Database - 21C | Create User, Delete User and Grant Permission to User using CDB and PDB
Vložit
- čas přidán 27. 11. 2022
- 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
• Oracle Database Instal...
--------------------------------------------
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 - Věda a technologie
I have suffered a lot with Oracle 21c Sql Plus connection and user creation, Your Explanation is great, thank you so much.
Thank you.
Very informative video!! Thanks. Was facing issues understanding Oracle terminologly from a MySQL background.
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!!
thank you so much, i couldnt create the user because of c##, this was very helpful
Thanks.
Thank you for the explanation!
Nice explain and thank you for put the code in description box
a lot of thanks ❤
Thank you sir.
Just want to say thanks man. Really nice video. Save me here. :)
Thank you.
Thanks, I am a newbie, and I was able to follow.
Glad u did.
Thank you - Excellent
Your most welcome.
Nice explanation
Excellent Explanation ...sir make video for dropping user
Sure, I will..
Excellent Explanation...sir kindly make video for how to delete users
Sure, I will..
Hi there, I am trying to setup new oracle environment. I downloaded Oracle 21C -XE. In SQL-Plus, I am able to connect using "sys as sysdba" with its password, but when I am trying to create new connection in SQL Developer, its throwing me this error: ora-1017 invalid username/password logon denied.
I am trying to find a solution from past couple of hours. Can you please assist on this issue??? This will be really helpful. Thanks,
Great Job
Thanks
Tried to login from cmd sqlplus error user is not connected to oracle. Login denied
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 ??
Let us figure it out. What do you think, ora-01031 means? Did u do some research on it?
when I try to do the cmd step it shows ora-12504
if anyone has a solution
Let us figure it out. What do you think, ora-12504 means? Did u do some research on it?
@@IntegrationAnarchy it’s say that the listener wasn’t given the service name but when I go to the file everything looks like the solve I found on oracle website and stack overflow but the message come back when I try again
@@princezen6849 Let's do 1 thing, try installing older version and see what is happening at the lower version.
n well how can i delete a user n his connection?
By executing the DROP command.