Creates a user named jason with a password of pass : Create User « User Privilege « Oracle PL/SQL Tutorial






SQL>
SQL> --CONNECT system/manager
SQL> CREATE USER jason IDENTIFIED BY pass;

User created.

SQL>
SQL> DROP USER jason;

User dropped.








36.1.Create User
36.1.1.Creating a User
36.1.2.Create user and assign password
36.1.3.Creates a user named jason with a password of pass
36.1.4.Create user with storage quota
36.1.5.User space
36.1.6.Creates a user named henry and specifies a default and temporary tablespace
36.1.7.Create User Utility
36.1.8.create user with temporary tablespace, quota and default tablespace
36.1.9.Display current user
36.1.10.Alter user to change the password