Oracle Database - 21C | Create User, Delete User and Grant Permission to User using CDB and PDB
14.5 هزار بار بازدید -
2 سال پیش
-
In the following video, we
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
https://www.seevid.ir/fa/w/JrlSXQ6h0po
--------------------------------------------
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
2 سال پیش
در تاریخ 1401/09/07 منتشر شده
است.
14,504
بـار بازدید شده