Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖÐ×ÔÔö×ֶεĴ´½¨

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

oracle´æ´¢¹ý³ÌÓï·¨

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨ ¼°×¢ÒâÊÂÏî
oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«selec ......

oracleȨÏÞ¹ÜÀí

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

oracleÖÐÅжÏÒ»¸ö×Ö·û´®ÊÇ·ñÈ«²¿ÎªÊý×ֵĺ¯Êý

參¿¼:http://blog.csdn.net/rainnyzhong/archive/2009/01/09/3740660.aspx
×÷ÕߣºRainny
ÈÕÆÚ£º2009-1-8
´´½¨²âÊÔ±í£º
create table test(c_id   varchar2(20));
²åÈë²âÊÔÊý¾Ý£º
insert into test values ('1234');
 insert into test values ('45678');
 insert into test values ('-12 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ