Table access between Oracle users and account locking and unlocking

I. Table access between users:

1. For example, if a bkjia user wants to access the users table in the system user, the command is as follows:
2. :
3. Grant select on users to bkjia;
5. Bkjia users can only query the users table data in the system user .)
7. You can run the following command to add, delete, modify, and query rows:
9. Grant all on users to bkjia;
11. Note: When you query a table in the system user in bkjia, you must add system. For example:
12. Select * from system. users;

Ii. account locking and unlocking

1. Account locking (profile)
3. Overview: specify the maximum number of times and number of days that can be entered when logging on to this account
5. For example, if you specify bkjia users to log on for a maximum of three times, the number of locked days is 2 days.
7. A) create an SQL command:
9. Create profile bkjia_lock limit failed_login_attempts 3 password_lock_time 2;
11. B) Execute the SQL command:
13. Alter user bkjia profile bkjia_lock;
15. Account unlock
16. SQL command: alter user bkjia account unlock;

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12