How to Create User in Oracle Database?

    0
    21
    Spread the love
    • 1
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
      1
      Share

    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

    Don't miss out!
    Subscribe To Newsletter

    Receive top technical news, lesson ideas, travel tips and more!

    Invalid email address
    Give it a try. You can unsubscribe at any time.

    Spread the love
    • 1
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
      1
      Share

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here