Views?

Alright; I'm confused...

SQL> describe dba_users;

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------
 USERNAME                                  NOT NULL VARCHAR2(30)
 USER_ID                                   NOT NULL NUMBER
 PASSWORD                                           VARCHAR2(30)

<<snip>>

SQL> create or replace view show_users as   2 as select username, account_status
  3 from dba_users
  4* order by username
SQL> /
from dba_users

     *
ERROR at line 3:
ORA-00942: table or view does not exist

Yet...

SQL> create or replace view show_tables as   2 select table_name
  3 from user_tables
  4 order by table_name;

View created.

I'm suspecting some type of squirrely priviledge problem. Can anyone tell me what I'm screwing up?

Thanks.

Doug  

-- 
------------------------
Douglas K. O'Leary
Senior System Administrator
dkoleary_at_mediaone.net