Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Oracle Database - 21C | Create User, Delete User and Grant Permission to User using CDB and PDB. That video is uploaded by Integration Anarchy at 2022-11-28T04:16:57-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [dzM_56uNWg0]
| Name | Oracle Database - 21C | Create User, Delete User and Grant Permission to User using CDB and PDB |
| Video Uploader | Video From Integration Anarchy |
| Upload Date | This Video Uploaded At 28-11-2022 12:16:57 |
| Video Discription | 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://youtu.be/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 dzM_56uNWg0 |
| Category | Science & Technology |
| Tags | online class | online tutorial | online training | computer programming | computer training | software development | software training | oracle | oracle database | oracle database express edition | oracle 21c | oracle training | oracle online classes | oracle 19c | oracle training session | oracle pluggable database | oracle container database | oracle create user | oracle delete user | oracle grant permission | oracle database 21C |
