Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

OracleÖÐ×ÔÔö×ֶεĴ´½¨

²½Ö裺
1.Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
       CREATE TABLE example(
             ID Number(4) NOT NULL PRIMARY KEY,
             NAME VARCHA ......

oracle Êý¾ÝÀàÐÍ


µ±ÄãÔÚÊý¾Ý¿âÖд´½¨Êý¾Ý±íµÄʱºò£¬ÄãÐèÒª¶¨Òå±íÖÐËùÓÐ×ֶεÄÀàÐÍ¡£ORACLEÓÐÐí¶àÖÖÊý¾ÝÀàÐÍÒÔÂú×ãÄãµÄÐèÒª¡£Êý¾ÝÀàÐÍ´óÔ¼·ÖΪ£ºcharacter, number, date, LOB, ºÍRAWµÈÀàÐÍ¡£ËäÈ»ORACLE8iÒ²ÔÊÐíÄã×Ô¶¨ÒåÊý¾ÝÀàÐÍ£¬µ«ÊÇËüÃÇÊÇ×î»ù±¾µÄÊý¾ÝÀàÐÍ¡£
ÔÚÏÂÃæµÄÎÄÕÂÖÐÄ㽫Á˽⵽ËûÃÇÔÚoracle ÖеÄÓ÷¨¡¢ÏÞÖÆÒÔ¼°ÔÊÐíÖµ¡£
¡¡¡¡
......

ORACLEÈçºÎ¸ù¾ÝITLÕÒµ½Ç°¾µÏñµÄ

SQL> select * from emp where sal=800;
EMPNO ENAME      JOB         MGR HIREDATE          SAL      COMM DEPTNO
----- ---------- --------- ----- ----------- ----- ......

[轉載]ORACLE¼Æ»®(schedule)Ïê½â

. ´´½¨job
jobÊÇÊ²Ã´ÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ