oracle 系统用户密码已过期
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/17556483/
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
System users password has expired
提问by RNJ
I have just tried to login to my db via sql developer as system so i can create a new user. It has come with an error that the password has expired.
我刚刚尝试通过 sql developer 作为系统登录到我的数据库,以便我可以创建一个新用户。它带有密码已过期的错误。
I have googled a bit but cannot see how to reset the system user password. I guess this is a security issue.
我用谷歌搜索了一下,但看不到如何重置系统用户密码。我想这是一个安全问题。
My problem is how can I log in as system if the password has expired? How can I unexpire the password without logging in as System users. I seem to be stuck here in a loop where I cannot reset the password expiration.
我的问题是,如果密码已过期,我如何以系统身份登录?如何在不以系统用户身份登录的情况下取消密码过期。我似乎陷入了无法重置密码过期的循环中。
回答by jDeveloper
Open up cmd.exe
and type in SQLPLUS
打开cmd.exe
并输入 SQLPLUS
Enter user-name: SYSTEM
Enter password: the expired password
It will now let you type in a new password for the SYSTEM user
现在,您可以为 SYSTEM 用户输入新密码
回答by BA TabNabber
If SQLPLUS is not available, you can also reset an expired password from within SQL Developer:
如果 SQLPLUS 不可用,您还可以从 SQL Developer 中重置过期密码:
- Save your connection information (if not done already)
- Right click on your connection
- Click on the “Reset Password” option in the menu, enter old/new password blah blah blah
- 保存您的连接信息(如果尚未完成)
- 右键单击您的连接
- 单击菜单中的“重置密码”选项,输入旧/新密码等等
回答by Sandro
If someone drops by from a Google search but uses IntelliJ:
You can reset the system password in the connection properties' "Advanced" tab. There you can set the new one as a value for the oracle.jdbc.newPassword
key.
如果有人通过 Google 搜索访问但使用 IntelliJ:您可以在连接属性的“高级”选项卡中重置系统密码。在那里您可以将新的设置为oracle.jdbc.newPassword
键的值。