Alter user to change the password : Create User « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. Create User
SQL>
SQL>
SQL> CREATE USER Alice IDENTIFIED BY simplepassword;

User created.

SQL>
SQL> ALTER USER Alice IDENTIFIED BY complicatedpassword;

User altered.

SQL>
SQL>
SQL> drop user alice;

User dropped.

SQL>
SQL>








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