I'm a bit confused; remedy permissions don't apply to db queries. With that said, the User form should have a record for the current user and the dynamic group access to the User record should allow the user to read their own record.
Axton On Thu, Jun 30, 2011 at 1:02 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > Are they using the API or going directly to the database? > If they access the DB directly then there is no permissions issue (as it > bypasses Remedy's permissions). > > Oh ... I see you state web Service. You could give them a specific web > service that doesn't use any parameters to bring back a single record for a > system available check. > > Personally I think aggregating their data would at least allow you to > control the query and load > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Reiser, John J > Sent: Thursday, June 30, 2011 12:48 PM > To: arslist@ARSLIST.ORG > Subject: Select statement to check for connectivity from external source > > Hello Listers, > > MS 2003 Enterprise SP1 on VMware > ARS 7.6.03 > MS SQL Server 2005 on remote SAN > > I have a department that is running select statements against the ARSystem > to run iDashboards. > They need a validation statement to confirm that the database is available. > Currently they run SELECT COUNT(*) FROM ARS_FORM WHERE 1=1 because I have > Unqualified searches disabled. > > I tried to point them to the group form with select group_name from Group > where Group_ID = 0 so they can verify that "Public" is returned. The problem > is that the Group form is only available to ARS Administrators. > > I know I can make a "Hello world!' form and store one record and give it > public permissions but I know the group form will always be there. Group is > a core form, Public is a core group. > > They also do a lot of Select statements with no WHERE clause against the > form to pull ticket information that they process and display on a web site > external to the ARSystem network through a web service. I am trying to keep > the load on the ARSystem manageable. > > Does anyone have any suggestions? > Should I add Public access to the group form but keep it hidden? Will an > upgrade reset the permissions? > Can I control the search qualification by altering the web service? > Should I aggregate their data for them and serve it up from a separate > form? > > This "Portal" will be getting hit by multiple people all day long. I don't > want the excess traffic slowing down the whole system. > > Thanks you, > > --- > John J. Reiser > Remedy Developer/Administrator > Senior Software Development Analyst > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"