Header Ads

How to Create User in Oracle Database?

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
Powered by Blogger.