通过修改profile 来修改账号的过期时间
转至：https://blog.csdn.net/xxzhaobb/article/details/80026028
查看账号的过期时间
SYS@test>select username,expiry_date from dba_users; USERNAME EXPIRY_DA ------------------------------ --------- MGMT_VIEW 22-JUN-18 SYS 22-JUN-18 SYSTEM 22-JUN-18 DBSNMP 22-JUN-18 SYSMAN 22-JUN-18 BB 24-SEP-18 OGG 24-SEP-18 OUTLN 24-AUG-13 FLOWS_FILES 24-AUG-13 MDSYS 24-AUG-13 ORDSYS 24-AUG-13 USERNAME EXPIRY_DA ------------------------------ --------- EXFSYS 24-AUG-13 WMSYS 24-AUG-13 APPQOSSYS 24-AUG-13 APEX_030200 24-AUG-13 OWBSYS_AUDIT 24-AUG-13 ORDDATA 24-AUG-13 CTXSYS 24-AUG-13 ANONYMOUS 24-AUG-13 XDB 24-AUG-13 ORDPLUGINS 24-AUG-13 OWBSYS 24-AUG-13 USERNAME EXPIRY_DA ------------------------------ --------- SI_INFORMTN_SCHEMA 24-AUG-13 OLAPSYS 24-AUG-13 SCOTT 24-DEC-17 ORACLE_OCM 24-AUG-13 XS$NULL 24-AUG-13 BI 24-DEC-17 PM 24-DEC-17 MDDATA 24-AUG-13 IX 24-DEC-17 SH 24-DEC-17 DIP 24-AUG-13 USERNAME EXPIRY_DA ------------------------------ --------- OE 24-DEC-17 APEX_PUBLIC_USER 24-AUG-13 HR 24-DEC-17 SPATIAL_CSW_ADMIN_USR 24-AUG-13 SPATIAL_WFS_ADMIN_USR 24-AUG-13 38 rows selected. SYS@test>
查看profile default
SYS@test>select * from dba_profiles where profile='DEFAULT'; PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED DEFAULT CPU_PER_SESSION KERNEL UNLIMITED PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- DEFAULT CPU_PER_CALL KERNEL UNLIMITED DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- DEFAULT IDLE_TIME KERNEL UNLIMITED DEFAULT CONNECT_TIME KERNEL UNLIMITED DEFAULT PRIVATE_SGA KERNEL UNLIMITED PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10 DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 16 rows selected.
修改profile，并查看账号的过期时间
SYS@test>alter profile default limit PASSWORD_LIFE_TIME unlimited; Profile altered. SYS@test> SYS@test>select username,expiry_date from dba_users; USERNAME EXPIRY_DA ------------------------------ --------- MGMT_VIEW SYS SYSTEM DBSNMP SYSMAN BB OGG OUTLN 24-AUG-13 FLOWS_FILES 24-AUG-13 MDSYS 24-AUG-13 ORDSYS 24-AUG-13 USERNAME EXPIRY_DA ------------------------------ --------- EXFSYS 24-AUG-13 WMSYS 24-AUG-13 APPQOSSYS 24-AUG-13 APEX_030200 24-AUG-13 OWBSYS_AUDIT 24-AUG-13 ORDDATA 24-AUG-13 CTXSYS 24-AUG-13
END
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识（上）
· 浏览器原生「磁吸」效果！Anchor Positioning 锚点定位神器解析
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布：重大改进与新特性概览！
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 单线程的Redis速度为什么快？