Remove user : User Password « User Previliege « Oracle PL / SQL






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

Remove 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>
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.Alter user to change the password
5.Drop the user if it exists
6.Get user name from all_users
7.Unassign Role from User