Namesake Views

2014-01-22 Thread Brittain, Mark
p_desk 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

Re: Namesake Views

2014-01-22 Thread LJ LongWing
o > 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 an

Re: Namesake Views

2014-01-22 Thread Charlie Lotridge
an 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 on aradmin.hpd_help_desk to > monitoringtool; > > > > Before today I did not know about these namesak

Re: Namesake Views

2014-01-22 Thread Grooms, Frederick W
custom database 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 parti

Re: Namesake Views

2014-01-23 Thread Lee Cullom
Of Brittain, Mark Sent: Wednesday, January 22, 2014 2:38 PM To: arslist@ARSLIST.ORG Subject: 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

Re: Namesake Views

2014-01-23 Thread Shelston, Patrick
list@ARSLIST.ORG] On Behalf 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-creat

Re: Namesake Views

2014-01-23 Thread Brittain, Mark
n, Patrick Sent: 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