: 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
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
: 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
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
;
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
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
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
7 matches
Mail list logo