Table access between users and account locking and unlocking

I. Table access between users:

For example, if the wangzihu user wants to access the users table of the System user, the command is as follows: grant select on users to wangzihu; (this is the command executed by the user for the system, in this case, if you are a wangzihu user, you can only query the users table data in the System user. If you want to add, delete, modify, and query the data in the system table, run the following command: grant all on users to wangzihu; note: When you query tables in the System user in the wangzihu user, you must add system, for example, select * from system. users;

Ii. account locking and unlocking

Profile Overview: specifies the maximum number of times and days that a user can enter a password when logging on to the account. For example, specify that a wangzihu user attempts to log on three times at most, and the number of days that the account is locked is 2 days) create SQL command: create profile wangzihu_lock limit failed_login_attempts 3 password_lock_time 2; B) Execute SQL command: Alter user wangzihu profile wangzihu_lock; account unlock SQL command: Alter user wangzihu account unlock;