Re: view not found
Date: Fri, 18 Jan 2008 18:31:10 +0100
<burrell.john_at_yahoo.com> schreef in bericht
> I have created, and run, as sysdba this script to create an user and a
> 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
> 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
> Please help me out!
Though the options by John Burell are correct, you could also:
Define a public synonym ADNAM for your view ADNAM.
I don't hope there's an Oracle error: Too many ADNAMS....
Shakespeare Received on Fri Jan 18 2008 - 11:31:10 CST