oracle ´úÀíÁ¬½ÓÎÊÌâ
ÇëÎÊoracle distinguished name ´úÀíÈÏÖ¤ÔõôÀÏÊÇ·µ»ØÓû§/ÃÜÂë´íÎó?
ÒÔÏ´úÂëÔÚÐèÒª/²»ÐèÒªÃÜÂëµÄÓû§Ãû´úÀíÈÏÖ¤ÖвâÊÔͨ¹ý
jdbc´úÂëÈçÏÂ:
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String connString = "jdbc:oracle:thin:@XXXXX:1521:test";
OracleConnection oc = (OracleConnection) DriverManager.getConnection(connString, "scott", "root");
parm = "CN=rad,OU=XXX,O=oracle,L=cd,ST=sc,C=zh";
info.setProperty("PROXY_DISTINGUISHED_NAME",parm);
oc.openProxySession(OracleConnection.PROXYTYPE_DISTINGUISHED_NAME, info);
ÔÚoracle ¶ËʹÓÃÃüÁî:
ALTER USER rad IDENTIFIED GLOBALLY AS 'CN=rad,OU=maesinfo,O=oracle,L=cd,ST=sc,C=zh';
ALTER USER rad GRANT CONNECT THROUGH scott AUTHENTICATED USING DISTINGUISHED NAME;
°´ÕÕoracle ¹Ù·½µÄÎĵµ.Ö»ÐèÒªÔÚjdbc¶Ë´«ÈëDN ×Ö·û´®¾ÍÐÐÁË..µ«ÊÇÎÒ²âÊÔÁ˶¼Ã»³É¹¦.²»ÖªµÀÄÄλÓоÑéµÄ´ó¸ç¸øµãָʾ°¢?
http://www.oracle.com/technology/products/ias/toplink/doc/10131/main/_html/dblgcfg008.htm
ÎÒÊǰ´ÕÕÂ¥ÉϵĹٷ½Îĵµ×öµÄ.Çë×Ðϸ¿´ÎÒµÄÌû×Ó.
°´ÕÕ¹Ù·½¸öÈËÀí½âÊÇ:ÓÃDNÌæ´úÁËpassword.
jdbcÁ¬½ÓµÄʱºòʹÓÃPROXY_DISTINGUISHED_NAME¾ÍOKÁË.
×îºóʼÖÕÊÇÓû§ÃÜÂë´íÎó.
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......