检查我的 Oracle 密码何时到期
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/26342839/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Check When MY Oracle Password Expires
提问by Joe DeRose
I have a non-admin login to an Oracle database, and I'd like to check when my password expires. I've found a lot of information online about getting password expiration dates by querying on the DBA_USERStable -- but I do not have privileges to view that table.
我以非管理员身份登录 Oracle 数据库，我想检查我的密码何时到期。我在网上找到了很多关于通过查询DBA_USERS表来获取密码到期日期的信息——但我没有查看该表的权限。
I'm hopeful that Oracle includes a way for me to check password expiration for my own login, but so far I've been unable to find any queries exceptthose that reference the DBA_USERStable.
我希望 Oracle 提供一种让我检查自己登录的密码过期的方法，但到目前为止，除了引用该DBA_USERS表的查询之外，我一直无法找到任何查询。
Is there a way for me to determine when my own password expires without putting in a ticket to the DBA?
有没有办法让我确定我自己的密码何时到期而无需向 DBA 提交票证？
回答by evenro
You can see the current user details using
您可以使用查看当前用户详细信息
select * from USER_USERS;
That will have a column name "expiry_date" which has the data you ask for.
那将有一个列名“expiry_date”，其中包含您要求的数据。
P.S. For almost every DBA_* there is an ALL_* (all the permitted records that the current user can see) and a USER_* (all the permitted records owned by the current user)
PS 对于几乎每个 DBA_* 都有一个 ALL_*（当前用户可以看到的所有允许记录）和一个 USER_*（当前用户拥有的所有允许记录）
so DBA_TABLES has all the tables the systems has, ALL_TABLES has all the tables the current user has permissions to do something on (update, delete, insert, modify, etc), and USER_TABLES - all the tables the current user created.
所以 DBA_TABLES 拥有系统拥有的所有表，ALL_TABLES 拥有当前用户有权对其执行某些操作（更新、删除、插入、修改等）的所有表，以及 USER_TABLES - 当前用户创建的所有表。
