SYSTEM user doesn't see a user in ALL

From: Otis Gospodnetic <otis_at_my-deja.com>
Date: Mon, 21 Feb 2000 22:53:35 GMT
Message-ID: <88sfle$q3n$1@nnrp1.deja.com>

Hello,

Is it normal for SYSTEM user not to see a user in ALL_USERS table, like in this example below?

prompt> sqlplus system/systempassword

SQL> select * from all_users where username='MYUSER';

no rows selected

SQL> connect myuser/mypass_at_mydb.domain.com Connected.
SQL> select * from all_users where username='MYUSER';

USERNAME                          USER_ID CREATED
------------------------------ ---------- -------------------
MYUSER                                 25 2000-01-27 16:44:38

Thanks,

Otis
P.S.
Is there a way to see what schemas MYUSER owns?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 21 2000 - 16:53:35 CST

SYSTEM user doesn't see a user in ALL_USERS