oracle ¶ÔÏóµÄÊÚȨ
Gold Country
OracleÊÚȨ
Ò»¡¢ÊÚȨÓï·¨
GRANT Óï·¨£º
1.ÏÔʽÊÚȨ(Ö±½Ó½«¶ÔÏóÊÚȨ¸øÓû§)
GRANT privilege [, ...] ON object [, ...] TO { Public| Group | Username|role} [WITH GRANT OPTION ]
2.ÒþʽÊÚȨ(ͨ¹ý½«½ÇÉ«ÊÚȨ¸øÓû§)
GRANT role TO { Public| Group | Username|role}
Ó﷨˵Ã÷£º
privilege (ȨÏÞ)
¿ÉÄܵÄȨÏÞÓУº
SELECT--·ÃÎÊÉùÃ÷µÄ±í/ÊÓͼµÄËùÓÐÁÐ/×ֶΣ®
INSERT--ÏòÉùÃ÷µÄ±íÖвåÈëËùÓÐÁÐ×ֶΣ®
UPDATE--¸üÐÂÉùÃ÷µÄËùÓÐÁÐ/×ֶΣ®
DELETE --´ÓÉùÃ÷µÄ±íÖÐɾ³ýËùÓÐÐУ®
RULE ÔÚ±í/ÊÓͼÉ϶¨Ò广Ôò £¨²Î¼û CREATE RULE Óï¾ä£©£®
ALL ¸³ÓèËùÓÐȨÏÞ£®
object ¸³ÓèȨÏ޵ĶÔÏóÃû£®
¿ÉÄܵĶÔÏóÊÇ£º
table £¨±í£©
view £¨ÊÓͼ£©
sequence £¨ÐòÁУ©
index £¨Ë÷Òý£©
Public ´ú±íÊÇËùÓÐÓû§µÄ¼òд£®
Group ½«Òª¸³ÓèȨÏÞµÄ×éGROUP £®Ä¿Ç°µÄ°æ±¾ÖУ¬×鱨ÐëÊÇÓÃÏÂÃæ·½·¨ÏÔʽ´´½¨µÄ£®
Username ½«Òª¸³ÓèȨÏÞµÄÓû§Ãû£®PUBLIC ÊÇ´ú±íËùÓÐÓû§µÄ¼òд£®
role ij¸ö½ÇÉ«£¬(ÈçDBA)
WITH GRANT OPTION ÔÊÐíÏò±ðÈ˸³ÓèͬÑùȨÏÞ,±»ÊÚȨµÄÓû§¿ÉÒÔ¼ÌÐøÊÚȨ.
ÃèÊö
¶ÔÏó´´½¨ºó£¬³ýÁË´´½¨ÕßÍ⣬³ý·Ç´´½¨Õ߸³Ó裨GRANT£©È¨ÏÞ£¬ÆäËûÈËûÓзÃÎʶÔÏóµÄȨÏÞ¡£
GRANT ÔÊÐí¶ÔÏóµÄ´´½¨Õ߸øÄ³Óû§»òij×é»òËùÓÐÓû§£¨PUBLIC£©Ä³Ð©Ìض¨µÄȨÏÞ¡£²»ÐèÒª¸ø´´½¨Õ߸³Ó裨GRANT£©¶ÔÏóµÄȨÏÞ£¬´´½¨Õß×Ô¶¯ÓµÓжÔÏóµÄËùÓÐȨÏÞ£¬°üÀ¨É¾³ýËüµÄȨÏÞ¡£
˵Ã÷
Oracle²»ÔÊÐíÔÚ¹ý³ÌÖÐʹÓÃδ¾ÏÔʽÊÚȨµÄ¶ÔÏó. ҪʹÓÃÁíÒ»Óû§µÄ¶ÔÏ󣬱ØÐëͨ¹ýÁíÒ»Óû§¸ø×Ô¼ºÏÔʾÊÚȨ¡£
ÒòΪOracleÔÚ±àÒë´æ´¢¹ý³Ìʱ²¢²»¼ì²é¶¨ÒåÕßÓµÓеĽÇÉ«£¬Ö»ÊǼì²éÆä±»ÏÔʽÊÚÓèµÄȨÏÞ£¬¶øDBAÒ²ÊÇÒ»ÖÖ½ÇÉ«£¬ËùÒÔ¼´Ê¹ÊÇDBA£¬Ò²ÐèÒªÏÔʽÊÚȨ¡£
¶þ¡¢ÊÚȨ·½Ê½ (ÏÔʽºÍÒþʽ)
¶ÔÏóÊÚȨÓÐÁ½ÖÖģʽ,ÏÔʽºÍÒþʽ:
ÏÔʾÊÚȨºÍÒþʽÊÚȨµÄÇø±ðÊÇ£ºÏÔʾÊÚȨÊÇÖ±½Ó°Ñ¶ÔÏóÊÚȨ¸øÓû§£¬ÒþʽÊÚ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä.
·ÖÅä´æ´¢£¬¾ÍÒª´´½¨±í¿Õ¼ä£º¡¡¡¡
´´½¨±í¿Õ¼äÊ ......
. ´´½¨job
jobÊÇÊ²Ã´ÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶ ......
Ò»¡¢¶¨Î»
¡¡¡¡oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracleµÄDevelop¹¤¾ß×öform¡£ÓеãÀàËÆÓÚ³ÌÐòÔ±£¬ÐèÒªÓнÏÇ¿µÄÂ߼˼άºÍ´´ÔìÄÜÁ¦£¬¸öÈ˾õµÃ»á±È½ÏÐÁ¿à£¬ÊÇÇà´º·¹J£»¹ÜÀíÔòÐèÒª¶ÔoracleÊý¾Ý¿âµÄÔÀíÓÐÉî¿ÌµÄÈÏʶ£¬ÓÐÈ«¾Ö²Ù×ݵÄÄÜÁ¦ºÍ½ôÃܵÄ˼ά£¬ÔðÈνϴó£¬ÒòΪһ ......