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

hi otis

you should see all users/schemes in your db from the all_users table. you can also look at dba_users when you login as system. is it possible, that you connect to two different databases?

• prompt> sqlplus system/systempassword
  • with this login, you are connecting to your local default database - connect myuser/mypass_at_mydb.domain.com
  • whereas with this login you are connecting to a possible different database on a local or remote computer

                                                           regards

thomas
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 - 10:04:18 CST