I've heard of this before, and my recollection is that people set up a script to re-grant needed permissions like this that they need and run after each release as part of the rollout procedure.
Question for the Oracle gurus out there: would it help to set up a level of indirection on this? Maybe create another view definitions such as: CREATE VIEW MyHelpdeskView AS SELECT * FROM aradmin.hpd_help_desk then grant the permissions to this and have the monitoring tool use it instead. This way (my perhaps naive thought is) the hpd_help_desk view can be dropped and recreated and it won't affect either the function or permissions of the MyHelpdeskView. Would this work? -charlie On Wed, Jan 22, 2014 at 11:38 AM, Brittain, Mark <mbritt...@navisite.com>wrote: > ** > > 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 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 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 > that monitoring tool could not query the view and the DatabaseError: > ORA-00942: table or view does not exist was being returned. > > > > One solution would be to grant the permission the monitoring tool anytime > the view is rebuilt. Not my favorite approach. Has anyone run into this and > come up with a better solution? > > > > ARS 7.6.04 > > ITSM 7.6.04 > > Oracle 11 > > > > Thanks > > Mark > > > > > > *Mark Brittain* > > Remedy Developer > > ITILv3 Foundation, Continual Service Improvement > > *NaviSite, Inc. – A Time Warner Cable Company* > > mbritt...@navisite.com > > Office: 315.634.9337 > > Mobile: 315.882.5360 > > [image: navsig] > > > > ------------------------------ > This E-mail and any of its attachments may contain Time Warner Cable > proprietary information, which is privileged, confidential, or subject to > copyright belonging to Time Warner Cable. This E-mail is intended solely > for the use of the individual or entity to which it is addressed. If you > are not the intended recipient of this E-mail, you are hereby notified that > any dissemination, distribution, copying, or action taken in relation to > the contents of and attachments to this E-mail is strictly prohibited and > may be unlawful. If you have received this E-mail in error, please notify > the sender immediately and permanently delete the original and any copy of > this E-mail and any printout. > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<image001.gif>>