Why Account Status Is Open When Expiry Date is Old Date in DBA_USERS

简介: Why Account Status Is Open When Expiry Date is Old Date in DBA_USERS

image.png

This is the expected behavior. The account status is updated only when the user will attempt to connect to the database while the expiry date is updated more frequently( when the user gets created, when the associated profile is modified, when the user is
altered, etc. ). If an user is not connecting to the database after the expiry date has passed then the ACCOUNT_STATUS will remain set to OPEN.
When this account is connecting to the database, the current date/time is compared with the value of EXPIRY_DATE. If EXPIRY_DATE is older than the current date/time then the system will check whether the PASSWORD_GRACE_TIME parameter is defined. If
it is set then the grace period is started, the account status is updated to "EXPIRED(GRACE)" and the EXPIRY_DATE is updated to a date which shows when the the account will be locked out.

相关文章
|
安全 Java 测试技术
【代码审计篇】 代码审计工具Fortify基本用法详解
本篇文章讲解代码审计工具Fortify的基本用法,感兴趣的小伙伴可以研究学习一下,文中部分地方可能会有遗漏,麻烦各位大佬指正,深表感谢!!!
2981 1
|
存储 Ubuntu Linux
sudo apt update和sudo apt upgrade有啥区别
【4月更文挑战第1天】
5826 4
|
JavaScript
封装echarts china map geo实现dispatch触发geoSelect事件高亮显示某个省份和城市,并定义复杂样式
封装echarts china map geo实现dispatch触发geoSelect事件高亮显示某个省份和城市,并定义复杂样式
|
存储 缓存 前端开发
平台介绍-搭建赛事运营平台(8)
提到了字典是分级的,本篇具体介绍实现
|
存储 JSON 算法
「应用安全」OAuth和OpenID Connect的全面比较(上)
「应用安全」OAuth和OpenID Connect的全面比较
|
IDE Java 开发工具
Java商品采购管理系统(开源项目)
Java商品采购管理系统(开源项目)
707 0
|
JavaScript
uniapp:[Vue warn]: Failed to mount component: template or render function not defined. found in
uniapp:[Vue warn]: Failed to mount component: template or render function not defined. found in
1041 0
uniapp:[Vue warn]: Failed to mount component: template or render function not defined. found in
|
域名解析 网络协议 网络安全
给自己github绑定的域名加个绿锁头https
给自己github绑定的域名加个绿锁头https
465 0
给自己github绑定的域名加个绿锁头https
|
存储 Oracle 关系型数据库
ORACLE DBA_OBJECTS视图中OBJECT_TYPE为LOB的对象查看
在ORACLE数据库中,DBA_OBJECTS视图中OBJECT_TYPE为LOB的对象是什么东西呢?其实OBJECT_TYPE为LOB就是大对象(LOB),它指那些用来存储大量数据的数据库字段。下面演示一下: CREATE TABLE TEST (        "ID"   NUMBER,...
2184 0
|
SQL Oracle 关系型数据库

热门文章

最新文章