幸运飞艇停吗

ASP源碼.NET源碼PHP源碼JSP源碼JAVA源碼DELPHI源碼PB源碼VC源碼VB源碼Android源碼
當前位置:首頁 >> 數據庫 >> Oracle >> 修改ORACLE數據庫密碼有效期的方法

修改ORACLE數據庫密碼有效期的方法

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

BENPIANWENZHANGZHUYAOJIESHAOLE" XIUGAIORACLESHUJUKUMIMAYOUXIAOQIDEFANGFA",ZHUYAOSHEJIDAOFANGMIANDENEIRONG,DUIYUOracleGANXINGQUDETONGXUEKEYICANKAOYIXIA: XIUGAIFANGFAZAICHENGXUYUNXINGGUOCHENGZHONG,CHANGCHANGHUIYINWEISHUJUKUMIMAGUOQIERSHICHENGXUWUFAZHENGCHANGFANGWEN。WEIJIEJUEZHEYIWENTI,KECAIYONGRUXIAFANGFA:1.CHAKANYONGHUDEproifleSHINAGE,YIBANSHIdefault...

XIUGAIFANGFA

ZAICHENGXUYUNXINGGUOCHENGZHONG,CHANGCHANGHUIYINWEISHUJUKUMIMAGUOQIERSHICHENGXUWUFAZHENGCHANGFANGWEN。WEIJIEJUEZHEYIWENTI,KECAIYONGRUXIAFANGFA:

1.查看用戶的proifle是哪個,一般是default SELECT username,PROFILE FROM dba_users;

2.CHAKANZHIDINGGAIYAOWENJIAN(RUdefault)DEMIMAYOUXIAOQISHEZHI:

SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

幸运飞艇停吗3.JIANGMIMAYOUXIAOQIYOUMORENDE180TIANXIUGAICHENG“WUXIANZHI”:

 ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

總結

YISHANGSUOSHUSHIXIAOBIANGEIDAJIAJIESHAODEXIUGAIORACLESHUJUKUMIMAYOUXIAOQIDEFANGFA,XIWANGDUIDAJIAYOUSUOBANGZHU,RUGUODAJIAYOURENHEYIWENQINGGEIWOLIUYAN,XIAOBIANHUIJISHIHUIFUDAJIADE。ZAICIYEFEICHANGGANXIEDAJIADUIBENZHANWANGZHANDEZHICHI!

您可能感興趣的文章:

  • Oracle 數據庫忘記sys與system管理員密碼重置操作方法
  • oracle數據庫密碼到期怎么解決
  • Oracle數據庫用戶的密碼過期時間如何修改為永不過期
  • 修改oracle數據庫用戶名及密碼的方法
  • 登錄oracle數據庫時密碼忘記的解決方法

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

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

相關圖片

相關文章