Re: SYSTEM user doesn't see a user in ALL_USERS

Hi Otis,

Point 1: Do you connect to the same database instance ????

    It seems to me that you connect to two different instances and only within the second

    one MYUSER is defined.

Point 2: What do you mean by own. Each user has exactly one schema and vice versa.

   But it is possible to have rights to different schemas (grant ... on ... to ... )

Rgrds
Karsten

Otis Gospodnetic schrieb:

> 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 Tue Feb 22 2000 - 01:26:22 CST