How to create an oracle user through sqlplus

How to create an oracle user through sqlplus

1. Connect to the database for which you want to add a user through the system administrator
Or run the following command: connect system/manager @ user_datebase as sysdba; log on to sys to create a user.

2. Create a user and assign Permissions
Drop user asset cascade; delete all tables and Views under the user
Create user asset identified by asset; create an asset user and set the password
Grant connect, resource, DBA to asset; assign permissions to users

3. Use sqlplus to check whether the user has been added successfully.
Or run the following command: connect asset/asset @ user_datebase to log on to asset.