ÈçºÎ¶ÁÈ¡Oracle Óû§µÄ¿ÚÁî - Oracle / »ù´¡ºÍ¹ÜÀí
ÈçºÎ¶ÁÈ¡OracleÊý¾Ý¿âÏ usersÏÂÓû§µÄ¿ÚÁîÄØ£¿Ð»Ð»´ó¼Ò
SELECT username,PASSWORD from dba_users;
²»¹ýÄã¶Á³öÀ´Ò²Ã»Ó㬿ÚÁîÊǼÓÃܹýµÄ¡£
¶¥Â¥ÉÏ¡£
Áí alter user Óû§Ãû identified by ÐÂÃÜÂë; ÊǸü¸ÄÓû§µÄÃÜÂë¡£
SQL code:
select username,password from dba_users;
ÓÐûÓаѼÓÃÜÎļþ½âÃܵÄÃüÁî°¡£¿±¾ÈËÊÇOracleµÄ²ËÄñ£¬·Ç³£¸Ðл»ØÌûµÄ£¡
ÎÒÒ²ÊDzËÄñ,µ«ÎÒ¾õµÃÓ¦¸ÃûÓÐ!! ÆÚ´ý¥Ͻâ´ð!
SQL code:
select username, password
from dba_users;
LZ¾Í±ðÏë×ÅÒª¼ÓÃܽâÃܵŤ¾ßÁË£¬Ö»ÓÐÓÃsysµÄDBAÉí·ÝµÇ¼£¬½øÓû§¹ÜÀí²Ù×÷°É£¡
Èç¹ûÓÐDBAȨÏÞ£¬²»ÏëÐ޸ıðÈ˵ÄÃÜÂ룬ÇÒÏëÓÃÄǸöÓû§µÇ¼
Ïȱ£´æÄǸöÓû§µÄÃÜÎÄ
È»ºóʹÓÃalter user identfied by values "ÃÜÎÄ"£¬ÃÜÎÄ¿ÉÒÔÊÇÄã
ÒÑÖªµÄÒ»¸öÓû§µÄÃÜÂëµÄÃÜÎÄ£¬ÕâÑùÄã¾Í¿ÉÒԵǼÁË
µÇ¼Íêºó£¬ÔÙʹÓÃÉÏÃæµÄÃüÁî¸Ä»ØÈ¥
¹Û¿´£¬½Ó·Ö
¹Û¿´£¬½Ó·Ö
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒ°²×°ÁËoracle 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......