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–

    Ads code goes here
    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  How To Code Advanced Search In Java

    Leave a Comment

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