Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news-out.superfeed.net!propagator2-maxim!news-in-maxim.spamkiller.net!news.he.net!newsfeed1.easynews.com!easynews.com!easynews!news.alt.net!plato.usenetgateway.com!not-for-mail From: zehst01 Newsgroups: comp.databases.oracle.tools Subject: Re: ORA-00980, but public synonym is there (in Oracle Reports). Date: Tue, 09 Sep 2003 16:46:19 -0400 Organization: dBforums Lines: 19 Sender: zehst01 Message-ID: <3349746.1063140379@dbforums.com> References: User-Agent: dBforums X-Original-NNTP-Posting-Host: db1.hotscripts.net X-Original-Trace: 9 Sep 2003 21:02:12 GMT, db1.hotscripts.net X-Authenticated-User: usenetgateway Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:82899 I was wrong. It was not the case sensitivity. If I go into SQL Worksheet as user with the DBA role but connect as Normal the public synonyms object owner appears owned by that user as I am use to. If I connect as SYSDBA then the object owner appears as SYS. Then when I run another script I get the ora-00980. The heart of the issue, at least in my circumstance, is the fact that the Public Synoynms Object Owner is appearing as Sys. I simply never encountered this is in 817 and am now seeing this in 9i Maybe it is coincidence and/or user error. I note that Jan requested observations which is what my replies have been, not extensive analysis. Steven -- Posted via http://dbforums.com