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.

相关文章
|
23天前
|
SQL 关系型数据库 MySQL
已解决:mysql报错> 1067 - Invalid default value for ‘comment_date‘ [DTF] 2> wp_links: Getting
已解决:mysql报错> 1067 - Invalid default value for ‘comment_date‘ [DTF] 2> wp_links: Getting
26 5
|
10月前
|
Ubuntu 数据安全/隐私保护
All data created during this guest session will be deleted when you log out 问题的解决
All data created during this guest session will be deleted when you log out 问题的解决
EnvironmentNotWritableError: The current user does not have write permissions to the targe...
EnvironmentNotWritableError: The current user does not have write permissions to the targe...
1842 0
SAP MM 如何通过SAP User ID拿到User的基本信息?
SAP MM 如何通过SAP User ID拿到User的基本信息?
SAP MM 如何通过SAP User ID拿到User的基本信息?
|
关系型数据库 MySQL 数据库
[Err] 1143 - SELECT command denied to user 'XX'@'%' for column 'XXX' in table 'XX'
[Err] 1143 - SELECT command denied to user 'XX'@'%' for column 'XXX' in table 'XX'
246 0
[Err] 1143 - SELECT command denied to user 'XX'@'%' for column 'XXX' in table 'XX'
|
存储
One order里user status和system status的mapping逻辑
One order里user status和system status的mapping逻辑
107 0
One order里user status和system status的mapping逻辑
delete in ST05 trace - deletion will also lead to many DB access first
delete in ST05 trace - deletion will also lead to many DB access first
110 0
delete in ST05 trace - deletion will also lead to many DB access first
|
SQL 数据库管理 关系型数据库
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
测试环境:OEL6.5+Oracle 11g R2在进行执行计划测试的时候,遇到一个小问题。在用普通用户执行下面这条命令的时候,普通用户名为hhu,已经赋予了create session和resource权限。
1110 1
|
SQL
ORA-00030: User session ID does not exist.
同事在Toad里面执行SQL语句时,突然无线网络中断了,让我检查一下具体情况,如下所示(有些信息,用xxx替换,因为是在处理那些历史归档数据,使用的一个特殊用户,所以可以用下面SQL找到对应的会话信息): SQL> SELECT B.
1886 0
|
SQL 测试技术 数据库
0131 ORA-00942 and AUTHID CURRENT_USER
[20180131]ORA-00942 and AUTHID CURRENT_USER.txt --//偶尔写一个存储过程调用一些系统视图.经常遇到一些ORA-00942,有时候很烦.
1132 0