view not found

From: <burrell.john_at_yahoo.com>
Date: Fri, 18 Jan 2008 07:53:09 -0800 (PST)
Message-ID: <6933ba29-1b53-47be-9aee-581fa757e89f@s19g2000prg.googlegroups.com>


Hello,
I have created, and run, as sysdba this script to create an user and a view.
drop view ADNAM;
create view ADNAM as select Serial from reporter.status;

drop user ADNAM;
create user ADNAM identified by ADNAM;
GRANT CONNECT TO ADNAM;
GRANT RESOURCE TO ADNAM;
GRANT SELECT ON ADNAM to ADNAM;
GRANT UNLIMITED TABLESPACE TO ADNAM; But when I log in a ADNAM/ADNAM

SQL> connect ADNAM/ADNAM
Connected.
SQL> select * from ADNAM;
select * from ADNAM

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

Clearly view adnam does exist - but user ADNAM is not referencing it correctly?
Please help me out!

J Received on Fri Jan 18 2008 - 09:53:09 CST

Original text of this message