Oracle - Delete a User Account in Oracle

Delete a User Account in Oracle

Q

How To Delete a User Account in Oracle?

✍: FYIcenter.com

A

If you want to delete a user account and its associated schema, you can log in as SYSTEM and use the DROP USER command as shown in the following example:

>.\bin\sqlplus /nolog

SQL> connect SYSTEM/fyicenter
Connected.

SQL> DROP USER DEV CASCADE;
User dropped.

SQL> CREATE USER DEV IDENTIFIED BY developer ACCOUNT UNLOCK;
User created.

Note that CASCADE tells the server drop the associated schema.

⇒Managing Oracle User Accounts, Schema and Privileges

⇒⇒Oracle Database Tutorials

2019-07-09, 661👍, 0💬

Create a New User Account in Oracle
How To Create a New User Account in Oracle? If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> CREATE USER DEV IDENTIFIED BY dev... 2019-07-21, 738👍, 0💬

Grant CREATE SESSION Privilege in Oracle
How To Grant CREATE SESSION Privilege to a User in Oracle? If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the server: >.\bin\sqlplus /nolog SQL> connect SYSTEM/f... 2019-07-09, 735👍, 0💬

Change User Password in Oracle
How To Change User Password in Oracle? If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> ALTER USER DEV IDENTIFIED BY beginner; U... 2019-07-09, 735👍, 0💬

Delete a User Account in Oracle
How To Delete a User Account in Oracle? If you want to delete a user account and its associated schema, you can log in as SYSTEM and use the DROP USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> DROP USER DEV CAS... 2019-07-09, 662👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.