Spread the love

How to Create User in Oracle Database?

Spread the love

How to Create User in Oracle Database?

In a multiusers base database ,it is necessary to create users who can access a database to certain part or whole. This is necessary from security point of view.

Now we can divide the security into two groups

  1. System security–deals with access and operational level
  2. Data security–deals with use of database.

Now let us see how a user can be created in a database-
The syntax is–

Create user ‘user_name’ identified by ‘password’;




well let’s see in practical…




 Here I have created an user with username as ‘xxxx’…this user’s password will be ‘yyyy’
Simple huh!!!!

image credit: http://webindiasolutions.com/blog/wp-content/uploads/2011/11/3D_Data_Base.jpg




Spread the love
READ  How to Delete or Drop an User in Database
Animesh Chatterjeehttps://techtravelhub.com/
I am the founder and owner of the blog - TechTravelHub.com, always love to share knowledge on test automation,tools,techniques and tips.I am a passionate coder of Java and VBScript.I also publish articles on Travel ideas and great honeymoon destinations.Apart from these, I am a gear-head,love to drive across India. I have shared lots of articles here on How to travel several parts of India.Customization of cars aka car modification is my another hobby.Get in touch with me on ani01104@gamil.com

Related Articles

Comments

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Posts

Super Keyword in Java Simplified

Super Keyword Super Keyword in Java Simplified: Java defines a special...

Learn Object Repository in UFT in An Efficient and Fast Manner

Object Repository in UFT The post will cover the following...

Learn What Primary Tools For Test Automation

Primary Tools For Test Automation According to the Gartner report...

EDITOR PICKS


Spread the love