HELP !!! INTERNAL User mysteriously disappears...

[Brutus Buckeye]

Tried to log into DB via INTERNAL login. Kept getting repeated messages saying the user did not exist.

Went into SQL to try and change password and I get the following message...

ORA-01918: user 'INTERNAL' does not exist

What happened to my INTERNAL user ? Can anyone shed any light on what might have happened ?

[sysdba]

Is Oracle version 9i?

[Brutus Buckeye]

I'm sorry it is 8i

[sysdba]

SQL>alter user sys identified by change_on_install;
SQL>exit

sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Nov 17 13:59:23 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name: internal

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL>

[davey23uk]

internal isnt a user as such, its a mean by autneticating you via the os

show us exactly what you typed

[Brutus Buckeye]

Still having problems...

Does this help ???

Thanks in advance to all who reply..


SQL> ALTER USER INTERNAL IDENTIFIED BY NEWPASS;
ALTER USER INTERNAL IDENTIFIED BY NEWPASS
*
ERROR at line 1:
ORA-01918: user 'INTERNAL' does not exist


SQL> spool off;

[fraze]

You cant change the password for INTERNAL like that - its not a user as such, more like a privilege. Its the O/S that authenticating you - if you're being asked for a password then your most probably not the correct O/S user. Have a look at http://metalink.oracle.com/metalink/...&p_id=207959.1

[patel_dil]

To change the password of internal, see sysdba's reply above. Internal is not exactly a username. If you login as internal and do "show user" , it will show that you are logged in as "SYS".

HTH.