Re: view not found

From: shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 18 Jan 2008 18:31:10 +0100
Message-ID: <4790e263$0$85794$e4fe514c@news.xs4all.nl>

<burrell.john_at_yahoo.com> schreef in bericht news:6933ba29-1b53-47be-9aee-581fa757e89f_at_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
>

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

Original text of this message