Database users interact with the database through applications or utilities.

A typical user’s responsibilities include the following tasks:

• Entering, modifying, and deleting data, where permitted
• Generating reports from the data

Create User

The create user statement to create and configure a database user, which is an account through which you can log in to the database, and to establish the means by which Oracle Database permits access by the user.

You must have the CREATE USER system privilege. When you create a user with the CREATE USER statement, the user’s privilege domain is empty. To log on to Oracle Database, a user must have the CREATE SESSION system privilege. Therefore, after creating a user, you should grant the user at least the CREATE SESSION system privilege.

SQL> create user test identified by test123 ;

Drop User

The drop user statement allows to delete a user from the Oracle Database. If the user has schema objects, the drop user statement also can remove all the user’s schema objects along with the user.

SQL> drop user test cascade ;