Oracleѧϰ±Ê¼Ç

ȨÏÞ¹ÜÀí
Oracle 9i
3¸öĬÈÏÓû§
sys(³¬¼¶¹ÜÀíÔ±)       ĬÈÏÃÜÂ룺change_on_install
system£¨ÆÕͨ¹ÜÀíÔ±£©
ĬÈÏÃÜÂ룺manager
scott£¨ÆÕͨÓû§£©       ĬÈÏÃÜÂ룺tiger
Oracle 10g
sys£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
system£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
scott(ĬÈÏËø¶¨£¬ÏëÓõýâËø)
Æô¶¯Windowsϵͳ·þÎñ£º
ÃüÁîÐУº
lsnrctl start(Æô¶¯¼àÌý)
oradim -startup -sid orcl(Æô¶¯Êý¾Ý¿âʵÀý)
ÒÔ³¬¼¶¹ÜÀíÔ±Éí·ÝµÇ¼
sqlplus / as sysdba
show user;£¨Ó¦·µ»Ø“SYS”£©
create user lisi identified by lisi;(´´½¨Óû§lisi£¬byºó±ßÊÇÃÜÂë)
ÊÚȨ
grant £ã£ò£å£á£ô£å £ó£å£ó£ó£é£ï£î £ô£ï £ì£é£ó£é£»£¨ÊÚÓèµÇ¼µÄȨÏÞ£©
£ç£ò£á£î£ô £ã£ò£å£á£ô£å £ô£á£â£ì£å £ô£ï £ì£é£ó£é£»£¨ÊÚÓè´´½¨±íµÄȨÏÞ£©
£ç£ò£á£î£ô £õ£î£ì£é£í£é£ô£å£ä £ô£á£â£ì£å£ó£ð£á£ã£å£»£¨ÊÚÓè²»ÊÜÉÏÏ޵ıí¿Õ¼äµÄȨÏÞ£©
Óû§µÇ¼²¢×öÔöɾ¸Ä²é²Ù×÷
£ó£ñ£ì£ð£ì£õ£ó £ì£é£ó£é/£ì£é£ó£é£¨µÇ¼£©
£ã£ò£å£á£ô£å £ô£á£â£ì£å £í£ù£ô£á£â£ì£å £¨£é£ä¡¡£é£î£ô£©£»
£é£î£ó£å£ò£ô £é£î£ô£ï £í£ù£ô£á£â£ì£å £ö£á£ì£õ£å£ó£¨£±£©£»
£ä£ò£ï£ð £ô£á£â£ì£å £í£ù£ô£á£â£ì£å£»
°Ñ´´½¨È¨ÏÞÊÚÓèËùÓÐÓû§
grant create session to public;
³·ÏúȨÏÞ
£ò£å£ö£ï£ë£å £ã£ò£å£á£ô£å £ô£á£â£ì£å £æ£ò£ï£í £ì£é£ó£é£»
revoke unlimited tablespace from lisi;
²éѯµ±Ç°Óû§ÓµÓеÄȨÏÞ
£ó£å£ì£å£ã£ô * from user_sys_privs;
OracleÓÐÉÏ°Ù¸öȨÏÞ
¶ÔÏóȨÏÞ
grant select on mytab to lisi;
grant all on mytab to lisi;
revoke select on mytab from lisi;
revoke all on mytab from lisi;
select * from user_tab_privs;
¶ÔÏóȨÏÞ¿ÉÒÔ¿ØÖƵ½ÁÐ
grant update(name) on mytab to lisi;
grant insert(id) on mytab to lisi;
select * from user_col_privs;
×¢Ò⣺²éѯºÍɾ³ý²»ÄÜ¿ØÖƵ½ÁС£
//ddl dml dcl
ȨÏ޵Ĵ«µÝ
grant alter any table to lisi with admin option;
grant select on A to lisi with grant option;
½ÇÉ«
create role myrole;
grant create session to myrole;
drop role myrole;
×¢Ò⣺ÓÐЩϵͳȨÏÞÎÞ·¨Ö±½Ó¸³Óè½ÇÉ«
create table create any table
[alter table] alter any table
[drop table] drop any table
±íÊÇÊôÓÚijһ¸öÓû§µÄ¡£
½ÇÉ«²»ÊôÓÚij¸ö
Êý¾Ý¿âµÄÈýÖÖÑéÖ¤»úÖÆ
²Ù×÷ϵͳÑéÖ¤
Ã