That won't work because ARAdmin is the owner of the synonym.
------Original Message------
From: Lisa Kemes
To: Arslist
ReplyTo: Arslist
Subject: Re: View Forms and Synoyms....
Sent: May 27, 2009 12:27 PM

Thanks Fred.  I tried this, but I'm still getting the error. (Even though it's 
not captured on the SQL logs for some reason)

*/SELECT count(*) from all_tab_columns where table_name = 'COST_CENTER_V' and 
owner = 'DCC'
*/OK
*/SELECT table_name from all_synonyms where synonym_name = 'COST_CENTER_V' and 
owner = 'DCC'
*/OK 


Lisa

-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Grooms, Frederick W
Sent: Wednesday, May 27, 2009 12:12 PM
To: [email protected]
Subject: Re: View Forms and Synoyms....

Try adding in the owner of your synonym.

Here is an excerpt of the server SQL Log.  This is with 7.1.0 Patch 007 on 
Solaris w/Oracle 10i (Remote DB)

Attempting to create a View Form on "USER_VIEWS"

<SQL >  <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 
10:49:37.0270 */   
SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner 
= 'ARADMIN'   
<SQL >  <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 
10:49:37.0325 */OK   
<SQL >  <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 
10:49:37.0327 */   
SELECT table_name from all_synonyms where synonym_name = 'USER_VIEWS' and owner 
= 'ARADMIN'   
<SQL >  <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 
10:49:37.0574 */OK   
<SQL >  <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 
10:49:37.0575 */   
Error

------Original Message Truncated------

Dave
-------------------------
[email protected]
(Wireless)

Reply via email to