User Management under Oracle database

User Management under Oracle database

1. Create User

to create a user's basic command:

(1) must be administrator rights to create a user

(2) What is the command to learn to create a user

(3) The newly created user does not have any permissions, that is, the database cannot be connected

(4) permission must be granted

2, change the user password

3, after landing that the password is invalid, prompted to modify the password

4, Lock the user

5, unlock the user

6, delete the user

7. Display user

8, view all the tables under the user