I am looking at a new system and cannot login as a particular user. the ALL_USERS data dictionary shows the user but when I attempt to alter the users password then I get ORA-01918 user does not exist.
this database was recently moved to its present location.
any insight most appreciated.
given some comments I can provide the following:
SQL> select username,account_status from dba_users where username='GL_FORECAST';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
GL_FORECAST OPEN
SQL> alter user GL_FORCAST identified by flatpass;
alter user GL_FORCAST identified by flatpass
*
ERROR at line 1:
ORA-01918: user 'GL_FORCAST' does not exist
SQL> alter user "GL_FORCAST" identified by flatpass;
alter user "GL_FORCAST" identified by flatpass
*
ERROR at line 1:
ORA-01918: user 'GL_FORCAST' does not exist
Message was edited by: user521233