Re: Namesake Views

2014-01-23 Thread Lee Cullom
: Namesake Views ** HI All, The move from 6.3 (custom) to 7.6 ITSM always seems to have more surprises than I care to sustain. Anyway, I have a monitoring tool that queries the hpd_help_desk view. The monitoring tool is granted permission to the view using the command grant select

Re: Namesake Views

2014-01-23 Thread Shelston, Patrick
Of LJ LongWing Sent: Wednesday, January 22, 2014 2:55 PM To: arslist@ARSLIST.ORG Subject: Re: Namesake Views ** Mark, The way we combated this particular issue was to actually create a new db view, one that is defined specifically for your purposes, and is not re-created after every form change

Re: Namesake Views

2014-01-23 Thread Brittain, Mark
: Thursday, January 23, 2014 12:46 PM To: arslist@ARSLIST.ORG Subject: Re: Namesake Views ** This is what we do. We just re-create the AR view into a custom view and manage it manually from that point forward. For example, HPD_HELP_DESK would have a stable version called REPORTING__HPD_HELP_DESK

Namesake Views

2014-01-22 Thread Brittain, Mark
to monitoringtool; Before today I did not know about these namesake views. Last night I added a field to the HPD:HelpD Desk and this query broke. Apparently there is a script that runs, deletes rather than updates the view and builds a new view. The result is any grants assigned to the view are wiped

Re: Namesake Views

2014-01-22 Thread LJ LongWing
; Before today I did not know about these namesake views. Last night I added a field to the HPD:HelpD Desk and this query broke. Apparently there is a script that runs, deletes rather than updates the view and builds a new view. The result is any grants assigned to the view are wiped out. After

Re: Namesake Views

2014-01-22 Thread Charlie Lotridge
have a monitoring tool that queries the hpd_help_desk view. The monitoring tool is granted permission to the view using the command “grant select on aradmin.hpd_help_desk to monitoringtool; Before today I did not know about these namesake views. Last night I added a field to the HPD:HelpD

Re: Namesake Views

2014-01-22 Thread Grooms, Frederick W
views. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Wednesday, January 22, 2014 1:55 PM To: arslist@ARSLIST.ORG Subject: Re: Namesake Views ** Mark, The way we combated this particular issue