oracle 8 command can not work in oracle 9i

[borgliu]

Hi, all

I use the follow oracle command to change oracle user's password:
"alter user User_ID identified by new_Password "

This command can work in oracle 8/8i
also works in oracle 9i which upgrade from 8i
but can not work in new brend-new 9i(installed, not upgrade)

Is possible let this command to use in 9i(installed)
if not, we must modify many applications , it will spent lots of time

thanks.

 

[SantaMufasa]

Borgliu,

There must be something else wrong. There is no problem running your command on a newly installed 9i instance. Mine is such a freshly installed 9.2.0.4 instance:

SQL> select version from v$instance;

VERSION
-----------------
9.2.0.4.0

SQL> create user user_id identified by old_password;

User created.

SQL> alter user User_ID  identified by new_Password;

User altered.

Please copy and paste a re-run of your command with the resulting error message in a new post to this thread.

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:39 (20Jan04) GMT, 23:39 (19Jan04) Mountain Time)

 

[borgliu]

it shows:
ORA-28221: REPLACE not specified

but I found that when I disable a security funtion
the command is works.

the security function is "enforce password complexity"

I will check this function can be disable or not in our IT policy

thanks your help.

 

[SantaMufasa]

Borgliu,

The above error occurs when:
1) the changing user attempts to modify another user's password,
2) the password verification function is turned on,
3) the changer did not specify the original password, and
4) the user does not have the "alter user" system privilege.

If a user that possesses the "alter user with admin" option, grants the "alter user" privilege to the changing user, I believe you should be okay. Let us know.

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:58 (20Jan04) GMT, 10:58 (20Jan04) Mountain Time)