Alter user to change the password : User Password « User Previliege « Oracle PL / SQL






  1. Oracle PL / SQL
  2. User Previliege
  3. User Password

Alter user to change the password

   


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>








Related examples in the same category

1.create user chris identified by chris;
2.Change User password
3.make a password expire with the ALTER USER command
4.Drop the user if it exists
5.Get user name from all_users
6.Unassign Role from User
7.Remove user