SQL> alter user querydb identified by "xxxxx";
alter user querydb identified by "xxxxx"
*
ERROR at line 1:
ORA-28221: REPLACE not specified
密码快要过期,但改又改不了,真是急死人。
我查了一下alter user的语法,没有replace这一项啊。
我是通过dblink登录的,创建dblink的用户是querydb,不能改密码与这有关吗?
Cause: User is changing password but password verification function is turned on and the original password is not specified and the user does not have the alter user system privilege.
Action: Supply the original password
你有管理员权限吗,给他一个权限?我没用过dblink。。。。
最初由 cxy89173 发布
[B]Cause: User is changing password but password verification function is turned on and the original password is not specified and the user does not have the alter user system privilege.
Action: Supply the original password
你有管理员权限吗,给他一个权限?我没用过dblink。。。。 [/B]
You must have ALTER USER privilege.However, you can change yourown password without this privilege.
最初由 csq1980 发布
[B]SQL> alter user querydb identified by "xxxxx";
alter user querydb identified by "xxxxx"
*
ERROR at line 1:
ORA-28221: REPLACE not specified
密码快要过期,但改又改不了,真是急死人。
我查了一下alter user的语法,没有replace这一项啊。
我是通过dblink登录的,创建dblink的用户是querydb,不能改密码与这有关吗? [/B]
使用了profile作了限制了。自己修改密码需要指定原来的密码,就是防止有人在你登录后,偷偷给你修改了口令
可以:alter user username identified by newpass replace oldpass;
或者,让拥有alter user权限的用户给你重置一个新的密码