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>
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