How to Create User in Oracle Database?

Share and Enjoy !

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

Share and Enjoy !

READ  Tutorials on Oracle Application Development Framework - Oracle ADF

Leave a Reply

Your email address will not be published. Required fields are marked *