Change User password : User Password « User Previliege « Oracle PL / SQL






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

Change User password

 

SQL>
SQL> create user oracle_admin  identified by oracle_admin;

User created.

SQL>
SQL> grant create session, dba to oracle_admin;

Grant succeeded.

SQL>
SQL> alter user oracle_admin identified by oracle;

User altered.

SQL>
SQL> -- connect oracle_admin/oracle;
SQL>
SQL> DROP USER oracle_admin;

User dropped.

SQL>








Related examples in the same category

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