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

ϸ̸OracleµÄȨÏÞ

ÎÒÃǾ­³£Ì¸¼°OracleµÄȨÏÞ£¬±ÈÈçConnect£¬DBA£¬resource£¬ sysdba, select any
table,
select_catelog_roleÕâÑùһЩȨÏÞ£¬ÈÃÎÒÃÇÑÛ»¨çÔÂҵģ¬ÄÇôÈçºÎÀ´Çø·ÖÕâЩÖÖÀà·±¶àµÄprivilegeÖв»ÖÁÓÚÑÛÃÔÀëÄØ£¬Õâ¸öÎÄÕ½«
»á¶ÔÄãÔÚÕâ·½ÃæµÄÁ˽âÆðµ½°ïÖú¡£
    
 ÒÔÉÏÎÒÃÇ¿´µ½µÄÕâЩȨÏÞ£¬¶¼ÊÇ¿ÉÒÔͨ¹ýgrantÓï¾äÀ´½øÐÐȨÏÞ¸³Ó裬ͬʱҲ¿ÉÒÔÓùýrevokeÀ´½øÐÐȨÏÞÊջصIJÙ×÷µÄ£¬µ«ÊÇ£¬ËûÃÇËäÈ»¶¼
ÔÚgrantÀï³öÏÖ£¬µ«ÊÇÓи÷×ÔÓÐ×ű¾ÖʵIJ»Í¬¡£
    
 oracleÀïµÄȨÏÞÓÐÁ½ÖÖȨÏÞ£¬ÏµÍ³È¨Ï޺ͶÔÏóȨÏÞ£¬ËùνϵͳȨÏÞ£¬¾ÍÊÇoracleÀïÒѾ­hardcodeдËÀµÄȨÏÞ£¬ÕâЩȨÏÞ£¬ÎÒÃÇÊÇ
²»ÄÜ×Ô¼ºÈ¥À©Õ¹µÄ£¬±ÈÈçÉÏÃæÌáµ½µÄselect any table, create any table. create
tableµÈ£¬ÕâÀïµÄȨÏÞÒѾ­ÔÚoracleÀïÈ«²¿¹æ¶¨ºÃÁË£¬
ÎÒÃÇ¿ÉÒÔͨ¹ý²é¿´system_privilege_mapÕâ¸öÊý¾Ý×Öµä±íÀ´²é¿´ËùÒÔµÄoracleϵͳÄÚÖõÄȨÏÞ¡£
SQL> select * from system_privilege_map;
 PRIVILEGE NAME              
                   
    PROPERTY
---------- ---------------------------------------- ----------
        -3 ALTER SYSTEM      
                   
           0
        -4 AUDIT SYSTEM      
                   
           0
        -5 CREATE SESSION    
                   
           0
        -6 ALTER SESSION    
                   
            0
        -7 RESTRICTED SESSION    
                   
       0
    
&nb


Ïà¹ØÎĵµ£º

Oracle ·ÖÒ³

<!-- 
@Name£º·ÖÀàͳ¼ÆÃ÷ϸ
@Time£º2010.01.05
@author JZP
--->
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page language="java" import="wfc.service.database.DB"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.Resul ......

ORACLEÊý¾Ý¿â×Ô¶¯±¸·ÝÈÎÎñ

For win:
1¡¢Ð½¨Ò»¸öÅú´¦ÀíÎļþb.bat£¬¸ÃÎļþĿ¼ÏÂÒªÓÐexp.exeÎļþ
    Åú´¦ÀíÎļþÄÚÈÝ£º
  exp userid=user/passfile=i:\db%date:~0,10%.dmp log=i:\db%date:~0,10%.log
2¡¢Ð½¨ÈÎÎñ¹ØÁªb.batÎļþ¼´¿É¡£
For linux:
1¡¢Çе½oracleÓû§ÏÂн¨Ò»¸öÎļþ£¬Èçb.sh  £¬²¢¸³ÓÚ¿ÉÖ´ÐÐȨÏÞ c ......

Oracle È¡µÃµ±Ìì0ʱ0·Ö0ÃëºÍ23ʱ59·Ö59Ãë

--È¡µÃµ±Ìì0ʱ0·Ö0Ãë
select TRUNC(SYSDATE) from dual;
--È¡µÃµ±Ìì23ʱ59·Ö59Ãë(ÔÚµ±Ìì0ʱ0·Ö0ÃëµÄ»ù´¡ÉϼÓ1ÌìºóÔÙ¼õ1Ãë)
SELECT TRUNC(SYSDATE)+1-1/86400 from dual;
--È¡µÃµ±Ç°ÈÕÆÚÊÇÒ»¸öÐÇÆÚÖеĵڼ¸Ìì,×¢Ò⣺ÐÇÆÚÈÕÊǵÚÒ»Ìì
select to_char(sysdate,'D'),to_char(sysdate,'DAY') from dual;
--ÔÚoracleÖÐÈçºÎµÃ ......

Oracle ÊÕ¹ºSunÖ®ºóµÄÑÝÒ壺IBM ºÍSAPºÎÈ¥ºÎ´Ó

SunÖÕÓÚµ¹ÏÂÁË£¬Ò»¸ö²»µ«´´Ôì¼¼ÊõÉñ»°£¬¸øÊÀ½çIT¼¼Êõ´øÀ´¸ïÃüÐÔÓ°ÏìµÄ¹«Ë¾µ¹ÏÂÁË£¬ÎÒ»³ÄîËü¡£
ÎÒ¸öÈËÈÏΪORACLEºÍSUNµÄºÏ²¢£¬ÊÇÁ½¼Ò
¹«Ë¾µÄÐÒÊ£¬ORACLE½øÒ»²½ÍêÉÆÁ˲úÆ·Ïߣ¬²¢ÇÒ·ûºÏÁËĿǰSaaSºÍÔÆ¼ÆËãµÄÇ÷ÊÆ£¬³ÉΪһ¸öÔÚ²úÆ·ÏߺͷþÎñÉÏ¿ÉÒÔºÍIBM½øÐоºÕùµÄ¹«Ë¾£¬¶øSUNµÄ
¼¼Êõ¿ÉÄܻᱻORACLE¹«Ë¾µÄÓªÏúÄÜÁ¦·½·¨£¬Ê¹SUNµ ......

OracleËæ»úº¯Êý—dbms_random

1.»ù´¡ÈÏʶ   
  
DBMS_RANDOM°üµÄÏêϸÐÅÏ¢£º   
     select text   from all_source    
      where name = 'DBMS_RANDOM'    
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ