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






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