µÚ28Õ Oracle·þÎñÆ÷ÅäÖú͹ÜÀí
µÚ28Õ Oracle·þÎñÆ÷ÅäÖú͹ÜÀí
ÌáÆðÊý¾Ý¿â£¬µÚÒ»¸öÏëÆðµÄ¹«Ë¾Ò»°ã¶¼»áÊÇOracle¡£Oracle¹«Ë¾ÓÚ1977Äê³ÉÁ¢£¬×¨×¢ÓÚÊý¾Ý¿â²úÆ·µÄ¿ª·¢£¬ÔÚÊý¾Ý¿âÁìÓòÒ»Ö±¶¼´¦ÓÚÁìÏȵØ룬Æä²úÆ·¸²¸ÇÁË´ó¡¢ÖС¢Ð¡ÐÍ»úµÈÊýÊ®ÖÖ»úÐÍ£¬ÊÇÄ¿Ç°ÊÀ½çÉÏʹÓÃ×î¹ã·ºµÄ¹ØϵÊý¾Ý¿âϵͳ֮һ¡£±¾½ÚÒÔÆä×îеÄÊý¾Ý¿â²úÆ·Oracle 11gΪÀý£¬½éÉÜÈçºÎÔÚRed Hat Enterprise Linux 5.2ÉϴºÍ¹ÜÀíOracleÊý¾Ý¿â·þÎñÆ÷¡£
Ïà¹ØÎĵµ£º
ÎÒÃǶ¼ÖªµÀORACLE²»»á·¢ÉúËøÉý¼¶£¬Ëø¶ÔÓÚORACLEÀ´Ëµ²¢²»ÊÇϡȱ×ÊÔ´£¬ÎªÊ²Ã´DML lock¶ÔÓÚORACLEÀ´Ëµ²»ÊÇϡȱ×ÊÔ´£¬ÏÂÃæÀ´Ñ°ÕҴ𰸡£
SQL> select * from emp where sal>2999;
EMPNO ENAME JOB MGR HIREDATE ......
1.²é¿´ËùÓÐÓû§£º
select * from dba_users;
select * from all_users;
select * from user_users;
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ(Ö±½Ó¸³Öµ¸øÓû§»ò½ÇÉ«µÄϵͳȨÏÞ)£º
select * from dba_sys_privs;
select * from user_sys_privs;
3.²é¿´½ÇÉ«(Ö»Äܲ鿴µÇ½Óû§ÓµÓеĽÇÉ«)Ëù°üº¬µÄÈ ......
. ´´½¨job
jobÊÇʲôÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶ ......
OracleÊÚȨ
Ò»¡¢ÊÚȨÓï·¨
GRANT Óï·¨£º
1.ÏÔʽÊÚȨ(Ö±½Ó½«¶ÔÏóÊÚȨ¸øÓû§)
GRANT privilege [, ...] ON object [, ...] TO { Public| Group | Username|role} [WITH GRANT OPTION ]
2.ÒþʽÊÚȨ(ͨ¹ý½«½ÇÉ«ÊÚȨ¸øÓû§)
GRANT role TO { Public| Group | Use ......
Æô¶¯Êý¾Ý¿âÃüÁî·ÖΪÈý¸ö½×¶Î£º
startup nomount
alter database mount
alter database open
±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡¡¡select * from user_tab_privs;
±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
¡¡¡¡select * from user_sys_privs;
---------------------------------------------------------
ORACLEÖÐÊ ......