Create Schema/User in Oracle (SQL Developer)

Published: 17 March 2020
on channel: Tech Talk's with Naresh

44,446

305

#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant

Join Our Telegram Group:
https://t.me/techtalkswithnaresh

FOLLOW US :
============
YouTube : / techtalkwithnaresh

For More details Contact Us:

Email: nareshtech21@gmail.com
--------------------------------------------------------------------------------------------------------------------------------------------------------

This video will help them who are in the learning phase of PLSQL/SQL. If you have any doubt's regarding this video write in comment section. If you want any other video related to SQL please comment in comment section. Please Like, Share and Subscribe the video.

 In this video we will see how to create new schema
 How to grant privileges to new schema.
 How to ember the new schema in SQL Developer

-- Create new schema in oracle
-- Command to create the Schema/user
CREATE USER nareshk IDENTIFIED BY nareshk;

-- Command to Grant the privilege to schema user
GRANT ALL PRIVILEGES TO nareshk;

-- Command to check the schema/user is giving proper output or not
SELECT username, account_status FROM dba_users WHERE username = 'NARESHK';

On this page of the site you can watch the video online Create Schema/User in Oracle (SQL Developer) with a duration of hours minute second in good quality, which was uploaded by the user Tech Talk's with Naresh 17 March 2020, share the link with friends and acquaintances, this video has already been watched 44,446 times on youtube and it was liked by 305 viewers. Enjoy your viewing!

234