Create and delete Oracle users

Create and delete Oracle users
1. Create a user

The username created in oracle must be logged on as an administrator; otherwise, insufficient permissions will be reported. Create statement: create user username identified by password.

Example:

Ii. Change the password

If you change your password, you can directly use the statement "password username. If you change the password of another user, you must be an administrator or

System permission for alter user

Example:

3. delete a user

Generally, users are deleted as administrators. If other users delete users, the drop user permission is required.
Delete user statement: drop user Username [cascade] (ps: if the user has already created a table, the cascade parameter must be included)