Create Schema/User in Oracle (SQL Developer)

preview_player
Показать описание
#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant

Join Our Telegram Group:

FOLLOW US :
============

For More details Contact Us:

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

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';
Рекомендации по теме
Комментарии
Автор

Totally valuable your lectures, You deserve the Golden button from youtube.🙂🙂🙂

TriveniPydi
Автор

"Thank you kindly for the precise and clear explanation. I must say, your voice resembles that of Sachin Tendulkar, which I meant as a compliment."

shivarajulvekar
Автор

Good Explanation, Sir. I have a doubt, hope you solve it sir. My doubt is "Is the term Schema and User is same"?

siddhartharao
Автор

How to launch that editor and type the query. I didn't find anything to launch that editor to write the query to create a user

nivasrayana
Автор

Will this data base can be accessed by other system, if I share user /password to them. You used localhost as your hostname. I means that this will be in our system only, right. I want it be accessed by anyone who knows my credentials, then what should I do?

ueeabhishekkrsahu
Автор

Hi, I have downloaded the sql developer and when I tried to create user/schema Oracle SQL developer is not allowing me create user/schema and it is leading me to select connection dialog box. Please help.

sureshbe
Автор

Thanks for video. but I got an error while I am trying to create a schema as "65096. - "invalid common user or role name""

parniasamimi
Автор

Are these steps applicable for 12c to 21c database?

juniorizcortes