Home > PL/SQL, Technical > Creating User in Oracle 11g

Creating User in Oracle 11g

July 4, 2012

Syntax:

======

CREATE USER username IDENTIFIED BY password;

1.user name is a name you specify according to the naming rules of database object.

2.password follows the same rules, but password is case sensitive by default in 11g.

 

Example:

=======

CREATE USER karuvachi IDENTIFIED BY vellaiyan

 

 

Advertisements
Categories: PL/SQL, Technical
%d bloggers like this: