幸运飞艇停吗

ASP源碼.NET源碼PHP源碼JSP源碼JAVA源碼DELPHI源碼PB源碼VC源碼VB源碼Android源碼
當前位置:首頁 >> 數據庫 >> Oracle >> 修改oracle密碼有效期限制的兩種思路詳解

修改oracle密碼有效期限制的兩種思路詳解

來源:網絡整理     時間:2018-10-04     關鍵詞:

幸运飞艇停吗 BENPIANWENZHANGZHUYAOJIESHAOLE" XIUGAIoracleMIMAYOUXIAOQIXIANZHIDELIANGZHONGSILUXIANGJIE",ZHUYAOSHEJIDAOFANGMIANDENEIRONG,DUIYUOracleGANXINGQUDETONGXUEKEYICANKAOYIXIA: YOUYUXIANGMUDEYIGEbug,DAOZHIHAOJIGEXIANWANGXIANGMUDOUCHUXIANLEYICHANG。bugSHUOMING:oracle11g,JINGMOANZHUANGHOUYONGHUDEMIMAYOUXIAOQIMORENSHEZHIWEI180TIAN,180TIANHOUMIMAJIANGSHIXIAO,ora...

幸运飞艇停吗YOUYUXIANGMUDEYIGEbug,DAOZHIHAOJIGEXIANWANGXIANGMUDOUCHUXIANLEYICHANG。

bugSHUOMING:

oracle11g,JINGMOANZHUANGHOUYONGHUDEMIMAYOUXIAOQIMORENSHEZHIWEI180TIAN,180TIANHOUMIMAJIANGSHIXIAO,oracleHUITISHIYAOXIUGAIMIMA。

WOMENXIANGMUYONGDESHIjdbcLIANJIEoracleSHUJUKU,MEIFAZIDONGCHULIoracleDEZHEZHONGMIMACUOWUTISHI,ZHIJIEJIULIANJIEoracleSHIBAI。

JIEJUESILUYI:

DINGQIXIUGAISHUJUKUYONGHUMIMA。

JIEJUESILUER:

JIANGSHUJUKUMIMASHEZHIWEIYONGJIUYOUXIAO。

SILUYIJUYOUYIDINGDEANQUANBAOHUZUOYONG,DANYOUYUYEWUBUZHICHIXIUGAIYEWUBUJIANZHONGDESHUJUKUMIMAPEIZHI(BUJIANJIAODUO,XIUGAIGUOYUMAFAN,SUOYIGANCUIYAOQIUBUNENGXIUGAI,XIANGXIANGYOUDIANCUO),YUSHIJUEDINGCAIYONGSILUER。

JUTISHEZHIMINGLINGRUXIA:

JIADINGWOMENSUOSHIYONGDESHUJUKUYONGHUWEItest,MIMAWEItest123456

BUZOUYI:DENGLUoracleSUOZAIDElinuxFUWUQI(WOMENDEoracleJIASHEZAIlinuxFUWUQISHANG),ZHUYIYAOYONGdbaYONGHU。

幸运飞艇停吗BUZOUER:ZHIXING'sqlplus / as sysdba'

BUZOUSAN:SHURU'alter profile default limit password_life_time unlimited;'BINGHUICHE

幸运飞艇停吗BUZOUSI:SHURU'alter user test identified by test123456;'

幸运飞艇停吗BUZOUWU:SHURU'quit;'TUICHUsqlplus。

BUZOULIU:ZHONGQIGEGEYEWUBUJIAN,YIQIEOK。

幸运飞艇停吗XUYAOZHUYIDESHI,DUIYUDISIBU,KENENGHUISHIBAI,YINWEIoracleYOUKENENGSHEZHILEXIUGAIMIMASHIBUNENGYULISHIMIMAZHONGFUDEXIANZHI,WOMENKEYIXIANZHIXINGYIXIAMINGLINGQUDIAOXIANZHI,RANHOUZAIZHIXINGDISIBU。SUIRANDUIYUDISIBUERYANSHEZHIQIANHOUMIMAMEIYOUGAIBIAN,DANQUESHIBIYAODEMA,SHIJICESHIZHONGFAXIANJISHIZUOLEDISANBUCHULI,RUGUOBUZHIXINGDISIBU,jdbcLIANJIESHUJUSHIYIRANHUILIANJIESHIBAI。

'alter profile default limit password_reuse_max unlimited;'
'alter profile default limit password_reuse_time unlimited;'

幸运飞艇停吗ZAISHIYONGprofileBINGXIANGZHONGFULIYONGMIMADESHI,XUYAOMANZURUXIATIAOJIAN

幸运飞艇停吗1)password_reuse_timeHEpassword_reuse_maxDOUWEIunlimtedDESHIHOU

KEYISUIBIANZHONGZHI

幸运飞艇停吗2)DANGZHIDINGpassword_reuse_timeHEpassword_reuse_maxQIZHONGYIGE,LINGWAIYIGEunlimtedDESHIHOU

MIMAYONGYUANWUFAZHONGZHI

3)DANGTONGSHIZHIDINGpassword_reuse_timeHEpassword_reuse_maxDESHIHOU

ZAIMANZUpassword_reuse_maxDESHIHOU,KEYIZHONGZHIMIMA

幸运飞艇停吗ZAITONGSHIMANZUpassword_reuse_timeHEpassword_reuse_maxDESHIHOU,KEYIZHONGZHIMIMA

幸运飞艇停吗ZAIMANZUpassword_reuse_timeDANCONGWEIGENGHUANGUOMIMADESHIHOU,YEJIUSHIpassword_reuse_maxYICIYEMEIYONGDESHIHOUMIMAWUFAZHONGZHI.

SHANGMIANZHEZHONGCHULIFANGANSHIXIUFUXIANWANGWENTIDEMIBUXINGCUOSHI,GENBENDEYAOZAIoralceANZHUANGDESHIHOUJIUQUDIAOMIMAYOUXIAOQIDEXIANZHI。

總結

YISHANGSUOSHUSHIXIAOBIANGEIDAJIAJIESHAODEXIUGAIoracleMIMAYOUXIAOQIXIANZHIDECAOZUOFANGFA,XIWANGDUIDAJIAYOUSUOBANGZHU,RUGUODAJIAYOURENHEYIWENQINGGEIWOLIUYAN,XIAOBIANHUIJISHIHUIFUDAJIADE。ZAICIYEFEICHANGGANXIEDAJIADUIBENZHANWANGZHANDEZHICHI!

您可能感興趣的文章:

  • 修改ORACLE數據庫密碼有效期的方法
  • Oracle 用戶密碼有效期的sql語句

幸运飞艇停吗 YISHANGJIUJIESHAOLE XIUGAIoracleMIMAYOUXIAOQIXIANZHIDELIANGZHONGSILUXIANGJIE,BAOKUOLEFANGMIANDENEIRONG,XIWANGDUIOracleYOUXINGQUDEPENGYOUYOUSUOBANGZHU。

BENWENWANGZHILIANJIE:http://snifly.cn/article/detail_4591660.html

相關圖片

相關文章