Oracle Rights Management

The Oracle database has just been installed today, the latest Oraclexe112_win32

Read the video of the Wisdom podcast, learn Oracle Create users and assign permissions to users, revoke permissions

3 Default Users
SYS change_on_install (password inside oracle9) [Be sure to write as SYSDBA]
System manager//A user-specified password at the beginning of Oracle10
Scott Tiger

CMD command to start monitoring: Lsnrctl start
Launch instance: Oradim-starup-sid oral

Show user;//display the current user name
Create user Lisi identified by lisi;//creating a subscriber Lisi and giving him the password Lisi
Assigning permissions to Lisi users through SYS
Grant create session to lisi;//gives Lisi permissions

(This is not the same as my test, this version of my sqlplus Lisi/lisi will pop up error invalid Username/password; Logon denied,

Then let you enter the user name, password, error, prompting user Lisi lacks CREATE SESSION privilege; Logon denied, said you did not create a session, and then use the SYS user to create a session. ）
Grant CREATE table to lisi;//gives Lisi permission to create tables, but even with this permission, a table space permission is required to create the table
Grant unlimited tablespace to Lisi;

When a table is created, the user has insert into, select,drop, and so on for this table, and does not require SYS assignment permission.
Revoke permissions
Revoke CREATE table from Lisi;

Oracle provides a special view to see what system permissions the current user has

SELECT * from User_sys_privs;

Oracle Rights Management