Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£¬Ò²ÐèÒªÏÔʽÊÚȨ¡£
¶þ¡¢ÊÚȨ·½Ê½ (ÏÔʽºÍÒþʽ)
  ¶ÔÏóÊÚȨÓÐÁ½ÖÖģʽ,ÏÔʽºÍÒþʽ: 
ÏÔʾÊÚȨºÍÒþʽÊÚȨµÄÇø±ðÊÇ£ºÏÔʾÊÚȨÊÇÖ±½Ó°Ñ¶ÔÏóÊÚȨ¸øÓû§£¬ÒþʽÊÚ


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle create tablespace

ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä.
·ÖÅä´æ´¢£¬¾ÍÒª´´½¨±í¿Õ¼ä£º¡¡¡¡
´´½¨±í¿Õ¼äÊ ......

ѧϰOracleÖÐSequencesµÄʹÓÃ

1. ´´½¨ Sequence
ʹÓÃÈçÏÂÃüÁîн¨sequence(Óû§ÐèÒªÓÐCREATE SEQUENCE »òÕßCREATE ANY SEQUENCEȨÏÞ):
CREATE  SEQUENCE test_sequence
INCREMENT  BY   1   --  ÿ´Î¼ÓµÄ¸öÊý¾Ý 
START  WITH   1   --  ´Ó1¿ªÊ¼¼ÆÊý 
NOMAXVALUE& ......

oracleȨÏÞ¹ÜÀí

Ò»¡¢ÏµÍ³µÄĬÈÏÓû§
Java´úÂë
sys;//ϵͳ¹ÜÀíÔ±£¬ÓµÓÐ×î¸ßȨÏÞ     
system;//±¾µØ¹ÜÀíÔ±£¬´Î¸ßȨÏÞ     
scott;//ÆÕͨÓû§£¬ÃÜÂëĬÈÏΪtiger,ĬÈÏδ½âËø  
¶þ¡¢µÇ½
Java´úÂë
sqlplus conn / as sysdba;//µÇ½sysÕÊ»§     ......

oracle ѧϰÐĵÃ

Ò»¡¢¶¨Î»
¡¡¡¡oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracleµÄDevelop¹¤¾ß×öform¡£ÓеãÀàËÆÓÚ³ÌÐòÔ±£¬ÐèÒªÓнÏÇ¿µÄÂß¼­Ë¼Î¬ºÍ´´ÔìÄÜÁ¦£¬¸öÈ˾õµÃ»á±È½ÏÐÁ¿à£¬ÊÇÇà´º·¹J£»¹ÜÀíÔòÐèÒª¶ÔoracleÊý¾Ý¿âµÄÔ­ÀíÓÐÉî¿ÌµÄÈÏʶ£¬ÓÐÈ«¾Ö²Ù×ݵÄÄÜÁ¦ºÍ½ôÃܵÄ˼ά£¬ÔðÈνϴó£¬ÒòΪһ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ