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)

