Oracle 问题总结 --- 修改用户过期限制

最新推荐文章于 2023-03-23 10:17:13 发布

weixin_33968104

最新推荐文章于 2023-03-23 10:17:13 发布

阅读量233

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/wangbinbin0326/blog/468817

版权

2019独角兽企业重金招聘Python工程师标准>>>

Oracle 修改用户过期限制

Oracle Database 默认情况下用户使用的期限是180天，就需要更改密码

#查看用户使用时间限制
SQL> select * from dba_profiles where resource_name = 'PASSWORD_LIFE_TIME';

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
------------------------------ -------------------------------- -------- ---------------
DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD 180
MONITORING_PROFILE             PASSWORD_LIFE_TIME               PASSWORD DEFAULT
PROF                           PASSWORD_LIFE_TIME               PASSWORD DEFAULT

#查看用户的过期时间
SQL> select username, expiry_date, created from dba_users where username = 'HR';

USERNAME                       EXPIRY_DA CREATED
------------------------------ --------- ---------
HR                             16-DEC-15 08-MAY-13

#更改用户无时间限制
SQL> alter profile default limit password_life_time unlimited;

Profile altered.

SQL> select * from dba_profiles where resource_name = 'PASSWORD_LIFE_TIME';

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
------------------------------ -------------------------------- -------- ---------------
DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD UNLIMITED
MONITORING_PROFILE             PASSWORD_LIFE_TIME               PASSWORD DEFAULT
PROF                           PASSWORD_LIFE_TIME               PASSWORD DEFAULT

SQL> select username, expiry_date, created from dba_users where username = 'HR';

USERNAME                       EXPIRY_DA CREATED
------------------------------ --------- ---------
HR                                       08-MAY-13

转载于:https://my.oschina.net/wangbinbin0326/blog/468817