prifile
来源:互联网 发布:北大方正软件技术学院 编辑:程序博客网 时间:2024/06/06 03:00
Stop a users password from expiring.
In 11g, a profile password expires by default at 180 days. This can be a pain, and the means to stop this is to create another profile with unlimited password lifetime, then assign it to the user.
SQL> select profile from dba_users where username = ‘APPADMIN’;
PROFILE
——————————
DEFAULT
SQL> select resource_name, limit from dba_profiles where profile = ‘DEFAULT’;
RESOURCE_NAME LIMIT
——————————– —————————————-
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7
16 rows selected.
So, the limit on the password is 180 days here, after which it will expire and stop logins on the account.
select txt from (select 0 pos, ‘create profile appprofile limit’ txt from dual
union
select rownum pos, resource_name||’ ‘||limit txt from dba_profiles where profile = ‘DEFAULT’ and limit ‘UNLIMITED’
union
select 999 pos, ‘/’ txt from dual)
order by pos;
TXT
————————————————————————-
create profile appprofile limit
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7
/
7 rows selected.
Change any limits you require and add others if needed. Then create the profile and assign it to the user.
SQL> create profile appprofile limit
2 FAILED_LOGIN_ATTEMPTS 10
3 PASSWORD_LIFE_TIME UNLIMITED
4 PASSWORD_VERIFY_FUNCTION NULL
5 PASSWORD_LOCK_TIME 1
6 PASSWORD_GRACE_TIME 7
7 /
Profile created.
SQL> alter user appadmin profile appprofile;
User altered.
- prifile
- oracle prifile
- spring-prifile各环境配置
- poj1029
- 动态规划解决公共子序列
- ExtJs_ExtchartChart类解释
- 解决 Flex navigateToURL 中文乱码问题
- 用C#打造"QQ对战平台挤房器"
- prifile
- 让CDialog响应WM_CHAR消息
- 快速以太网和以太网的区别 FDDI
- Map容器与multimap容器应用的小知识
- set_current_state 应用
- MultiByteToWideChar 和 WideCharToMultiByte 用法详解
- C# 实现桌面图片飘浮效果
- 在linux下进行编码格式转换
- 单例模式