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<mailto:mbritt...@navisite.com> Office: 315.634.9337 Mobile: 315.882.5360 [cid:image001.gif@01CF177D.290FDCD0] ________________________________ 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: image001.gif>>