DeFuser.Tk Blog

How To Create A User In Pl/SQL ?

 When we talk about Create a new user in PL/SQL then we think about System account (ADMINISTRATIVE ACCOUNT ). Once we connected as System account,
We issue the command

CREATE USER username IDENTIFIED BY userPassword;

Here you can see we issued a command CREATE USER ,the blue colour word username will be the new user name and the IDENTIFIED BY, Shows that this New user identified by this password.

FOR EXAMPLE

CREATE USER defuserali IDENTIFIED BY defuser123 ;