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
- System security–deals with access and operational level
- Data security–deals with use of database.
Now let us see how a user can be created in a database-
The syntax is–
well let’s see in practical…
Here I have created an user with username as ‘xxxx’…this user’s password will be ‘yyyy’
image credit: http://webindiasolutions.com/blog/wp-content/uploads/2011/11/3D_Data_Base.jpg