Log on to Oracle and create a user to grant permissions

Three default system users

Username and password

Sys change_on_install (highest Network Administrator)

Manager system local administrator

Scott tiger common user

1. Start the cmd command of the Oracle listener:

1: name of the lsnrctl start listener (not to be written)

2: Start the data instance oradim-startup-sid dataname (Instance name)

2. Log On with the highest user in sys

Sqlplus sys as sysdba (sqlplus username/password @ connection_String)

Create user lisi identified by lisi; // create a user lisi with the password Li Si

Grant session to lisi; // create the database access permission

Grant unlimited tablespace to lisi; // Let Li Si use the tablespace infinitely. At this time, Li Si can create a table (using the default sys tablespace)

Revoke the lisi permission

Revoke session from lisi;

Revoke unlimited tablespace from lisi;

3. The object permission Wang Wu can access table 4.

After user Wang Wu is created, Wang Wu creates a table tab.

Grant select on tab to lisi;

Grant all on tab to lisi;

5. revoke permissions

Revoke select on tab from lisi;

Revoke all on tab from lisi;

6. grant permissions to all users

Grant create session to public;

7. query your own permissions

Select * from user_sys_privs;