1、3個默認(rèn)的用戶
sys change_on_install [as sysdba]
system manager
scott tiger
2、創(chuàng)建用戶
create user lisi identified by lisi;
3、系統(tǒng)權(quán)限
grant create session to lisi;
grant create table to lisi;
grant unlimited tablespace to lisi;
revoke create session from lisi;
revoke create table from lisi;
revoke unlimited tablespace from lisi;
grant create session to public;
// 查看用戶的系統(tǒng)權(quán)限
select * from user_sys_privs;
4、對象權(quán)限
grant select on mytab to lisi;
grant all on mytab to list;
revoke select on mytab from lisi;
revoke all on mytab from lisi;
select * from user_tab_privs;// 查看用戶的對象權(quán)限
對象權(quán)限可以控制到列
grant update(name) on mytab to lisi;
grant insert(id) on mytab to lisi;
select * from user_col_privs;
注意：查詢和刪除不能控制到列
ddl:數(shù)據(jù)定義語言
dml:數(shù)據(jù)操縱語言----需要commit
dcl:數(shù)據(jù)控制語言
------------------------------------------------------------------------------
1.控制臺啟動監(jiān)聽----lsnrctl start
2.啟動數(shù)據(jù)庫的實例----oradim -starup -sid orcl
3.超級用戶登入----sqlplus / as sysdba
4.查看當(dāng)前用戶----show user;
5.創(chuàng)建用戶----create user tiane identified by tiane;
登錄成功：sqlplus tiane/tiane as sysdba
登錄失敗：sqlplus tiane/tiane-------------沒session（會話）權(quán)限
6.給用戶授權(quán)-會話權(quán)限---grant create session to tiane;
7.給用戶授權(quán)-建表權(quán)限---grant create table to tiane;
8.給用戶授權(quán)-使用表空間權(quán)限---grant unlimited tablespaces to tiane;
附：默認(rèn)表空間：USERS
9.撤銷用戶權(quán)限-建表權(quán)限---revoke create table from tiane;
10.查看當(dāng)前用戶的系統(tǒng)權(quán)限---- select * from user_sys_privs;
查看當(dāng)前用戶的對象權(quán)限---- select * from user_tab_privs;
附：系統(tǒng)權(quán)限，對象權(quán)限
11.系統(tǒng)用戶可以訪問普通用戶的表
select * from tiane.mytable;
12.普通用戶(tiane)訪問普通用戶(shui)的表，需要授權(quán)
grant select on mytab to tiane;
13.普通用戶給普通用戶授全部權(quán)限
grant all on mytab to tiane;
14.撤銷全部對象權(quán)限
revoke all on mytab from tiane;
附：加大寬度，避免換行set linesize 400
15.權(quán)限可以控制到列
grant update(name) on mytab to tiane;
grant insert(name) on mytab to tiane;
查看當(dāng)前用戶的對象權(quán)限---- select * from user_col_privs;
