Yes, aradmin has selected permissions against everything in those schemas. About 80 view forms :(
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Sunday, January 28, 2007 8:38 AM To: [email protected] Subject: Re: Oracle View Forms ** Does the ARSystem user have select access against that table? How many views do you have to redo? On 1/28/07, Tucker, Rob < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: ** I hope one of you good folks is working weekends :) I originally had the remedy database in it's own instance of oracle. For reasons knows only to the powers that be, we have moved the tablespace from it's own instance to a shared instance. The system runs fine except for all my view forms that previously used a db link to pull data. The view forms were built similar to: [EMAIL PROTECTED] where PHNXP.WORLD was the db link. Now that I am sharing a instance with the data I previously accessed using the dblink and since the dba's tell me a dblink cannot share the name as the instance, I have to redo the view forms. Trouble is when I attempt to create a view form as follows: OMS.OI_END_USER_VW I get this error: Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). You'll note that the schema.table name are identical to before and I have verified them as being correct. What am I missing? Thanks! -Rob ____________________________________________ Rob Tucker New Edge Networks ARS Administration and Development [EMAIL PROTECTED] Vancover,Washington tel: 360-759-9670 fax:360-693-9997 __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
