?????????
????create session
????create table
????unlimited tablespace
????connect
????resource
????dba
????????
????#sqlplus /nolog
????SQL> conn / as sysdba;
????SQL>create user username identified by password
????SQL> grant dba to username;
????SQL> conn username/password
????SQL> select * from user_sys_privs;
??????????????Oracle????????????????????????????????????Oracle????????и?????????
???????????
????sys;//???????????и????
????system;//???????????θ????
????scott;//????????????????tiger?????δ????
???????????
????sqlplus / as sysdba;//???sys???
????sqlplus sys as sysdba;//???
????sqlplus scott/tiger;//?????????scott
???????????????
????create user zhangsan;//??????????￡????????zhangsan
????alert user scott identified by tiger;//???????
??????????????
????1????????????scott???δ?????????????????????????????????κ????????????????
????grant create session to zhangsan;//????zhangsan???????session??????????????
????grant unlimited tablespace to zhangsan;//????zhangsan?????????????
????grant create table to zhangsan;//???貼????????
????grante drop table to zhangsan;//?????????????
????grant insert table to zhangsan;//?????????
????grant update table to zhangsan;//????????
????grant all to public;//???????????????????????(all)?????????(public)
????2??oralce???????????????????????????????????????????????????
????grant select on tablename to zhangsan;//????zhangsan??????????????
????grant drop on tablename to zhangsan;//?????????????
????grant insert on tablename to zhangsan;//???????????
????grant update on tablename to zhangsan;//????????????
????grant insert(id) on tablename to zhangsan;
????grant update(id) on tablename to zhangsan;//???????????????ε????????????????????insert??update
????grant alert all table to zhangsan;//????zhangsan???alert?????????
?????塢???????
???????????grant????????revoke
?????????????
????select * from user_sys_privs;//???????????????
????select * from user_tab_privs;//????????????????
????????????????????
????select * from zhangsan.tablename
?????????????
?????????A?????????B??B????????????????????C?????????￡?
????grant alert table on tablename to zhangsan with admin option;//????? with admin option
????grant alert table on tablename to zhangsan with grant option;//????? with grant optionЧ????admin????
??????????
????????????????????????????????????
????create role myrole;//???????
????grant create session to myrole;//??????session?????????myrole
????grant myrole to zhangsan;//????zhangsan???myrole????
????drop role myrole;??????