Database (Learning to organize)----2--authorization and access to Oracle user rights

Knowledge Points:
1, the user level used in Oracle database is peer! Only the permissions of each user are different!

2, after a user login, you can access other user's data buffer, table, and table operation in their own login state! (As long as the user with permissions!) ）

3, we can create user rights in a user login, create (give permission, etc.) operation, after the creation of the user and the current user is peer! Different permissions!
(1), using SYSDBA login to create a Jason user, password: abc123

SQL statements:
Create user Jason identified by abc123;

Post-execution effects:
User Jason has already been created, but cannot log in to Oracle because it has not been given login privileges (create session Permissions!). ）

(2), give user Jason to give login rights:

SQL statements:
Grant connect to Jason;

The effect after execution:
User Jason can log in to Oracle!
However, you cannot access the data buffers in the database!

(3), give the user Jason access to the data buffer:

SQL statements:
Grant resource to Jason;

The effect after execution:
However, it is still not possible to manipulate the tables in the database (Add and remove the check)!

(4), to the user Jason gave the table: Insert/delete/update/select operation Rights!

SQL statements:
(1): Grant all on SYSTEM.TESTTB1 to jason;//four permissions (additions and deletions)

(2): Grant Select on System.testtb1 to jason;//give Jason the ability to query the System User testTB1 table

And so on ...

(5) Reclaim Jason's privileges:

SQL statements:
(1): Recall and delete the permission to change the check.
Revoke all on system.testtb1 from Jason;
Or

Revoke insert,select,delete,update on SYSTEM.TESTTB1 from Jason;

(2): Revoke the specified permission:

Revoke [insert/select/delete/update] on system.testtb1 from Jason;

Revoke insert on SYSTEM.TESTTB1 from jason//reclaim new permissions
(6) Delete Jason User:

SQL statements:
Drop User Jason (cascade: Forced Discard);

The effect after execution:
(1) User Jason has been removed from the database and is no longer logged into Oracle! And the information under Jason's user will be deleted!

Database (Learning Grooming)----2--authorization and access to Oracle user rights