How to Create User in Oracle Database?

September 25, 2012

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:

You Might Also Like