OK. That would also be the case then if you were using any DB-based replication or indexing. In both cases the release procedures for making form changes would need to include steps to restore the AR System permissions to the view or rebuild the non-AR System indices on the form. Would that be an acceptable workaround?
Rick On Mon, Feb 22, 2010 at 12:13 PM, Roys, Eric D < [email protected]> wrote: > If you have given permissions to the view external to Remedy such as for > reporting user(s) for tools such as Actuate it is because you would need a > mechanism to re-apply the permissions. > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of Rick Cook > Sent: Monday, February 22, 2010 2:07 PM > To: [email protected] > Subject: Re: Remedy View Validation > > Ok, so it drops and recreates views. Is that really a bad thing? > > Rick > > -----Original Message----- > From: "Grooms, Frederick W" <[email protected]> > Date: Mon, 22 Feb 2010 14:03:10 > To: <[email protected]> > Subject: Re: Remedy View Validation > > No BS. I just ran a test ... It DOES delete and create the View. > I simply added a field to a dummy form as a test and looked at the SQL log. > This is on Solaris w/Oracle. > > Action Request System(R) Server Version 7.1.00 Patch 008 200911120530 > (c) Copyright 1991-2007 BMC Software, Inc. > > <SQL > <TID: 0000000004> <RPC ID: 0000000727> <Queue: Admin > <Client-RPC: > 390600 > <USER: me > /* Mon Feb 22 2010 13:54:12.4877 */DROP VIEW Template > <SQL > <TID: 0000000004> <RPC ID: 0000000727> <Queue: Admin > <Client-RPC: > 390600 > <USER: me > /* Mon Feb 22 2010 13:54:13.0786 */OK <SQL > <TID: > 0000000004> <RPC ID: 0000000727> <Queue: Admin > <Client-RPC: 390600 > > <USER: me > /* Mon Feb 22 2010 13:54:13.0792 */CREATE VIEW Template > (Request_ID,Submitter,Create_Date,Assigned_To,Last_Modified_By,Modified_Date,Status,Short_Description,Real_Number_Field,History,Keywords,Date_Time_Field,Date_Field,Start_Time_Field,Time_Field,JUNK) > AS SELECT > T25.C1,C2,C3,C4,C5,C6,C7,C8,C520000001,C536870915,C536870916,C540000054,C560000001,C560000002,C560000003,C560000006 > FROM T25 <SQL > <TID: 0000000004> <RPC ID: 0000000727> <Queue: Admin > > <Client-RPC: 390600 > <USER: me > /* Mon Feb 22 2010 13:54:13.1550 */OK > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of Joe D'Souza > Sent: Monday, February 22, 2010 1:49 PM > To: [email protected] > Subject: Re: Remedy View Validation > > ** > Views, it replaces.. It uses the syntax Create or Replace view as blah blah > blah.. If present it just replaces - if absent it creates.. > > Tables like Rick says, it used to rename, create a new one, copy data from > renamed table to new table, drop old.. Right now I'm not exactly sure what > it does when you alter table, maybe it just issues the good old alter table > statement?? > > Joe > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]]on Behalf Of Rick Cook > Sent: Monday, February 22, 2010 2:42 PM > To: [email protected] > Subject: Re: Remedy View Validation > ** I cry BS, too. Remedy USED to drop forms when a field was deleted, but I > don't think even that happens any more. > Rick > > -----Original Message----- > From: Tommy Morris <[email protected]> > Date: Mon, 22 Feb 2010 13:36:04 -0600 > To: <[email protected]> > Subject: Remedy View Validation > > AR 7.5p1 > Oracle 11g > We had a custom view built against HPD_Help Desk to facilitate external > reporting. This view was recently dropped and then recreated by some > "unknown entity" (I blame the kittens). When I asked our dba's about this > they responded that the Remedy Application drops views and recreates them > when a new field is added or moved around (customizing form views through > Developer/ Admin tool). > I of course cried BS but just wanted to ask the list; Has anyone seen where > modifying a form causes database objects to drop and recreate? > Tommy Morris > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor:[email protected] <sponsor%[email protected]>ARSlist: > "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
