oracle 如何只为一个用户设置用户 password_life_time？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/16021877/
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
How to set user password_life_time for only one user?
提问by Andriy Cherniy
This statement:
这个说法：
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME 180;
changes the password_life_timevalue for all users in my profile. But what if I need to change this value for only oneuser?
更改password_life_time我的个人资料中所有用户的值。但是如果我只需要为一个用户更改这个值呢？
Would I use something like this?:
我会使用这样的东西吗？：
ALTER username LIMIT PASSWORD_LIFE_TIME UNLIMITED
回答by Alex Poole
You can't do that directly through ALTER USER. You would need to create a new profile, configure that as you need, and then alter the user to pick up that profile.
你不能直接通过ALTER USER. 您需要创建一个新的配置文件，根据需要进行配置，然后更改用户以获取该配置文件。
It would be unusual to have a single user with specific requirements, and in most situations profiles are more flexible and efficient
有一个具有特定要求的单个用户是不寻常的，并且在大多数情况下，配置文件更加灵活和高效
