Jason:
That is a great solution and is going in my 'hold' box for ARS tips and tricks I keep.
This is the main reason I stay on the list is the sharing of solutions that BMC would not have.
James McKenzie
________________________________
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Tuesday, September 05, 2006 7:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: Disable ODBC
** I had a situation where I setup a contractor on a temporary basis with an ODBC connection to his MS Access database. We agreed that it was only for his use. He ended up placing it on a network share and letting everybody know it was there. I had some big performance concerns about multiple people starting to do a full dump of the CHG:Change and CHG:Task tables each time they want to see the latest data. Fortunately he pulled it before anybody had a chance to copy it.
I created a filter that fires on Get Entry. The Run If was $CLIENT-TYPE$ = 6 and $USER$ != "myusername" and I had a error message If Action. This gave me (logged in as a different user) an error in MS Access and Crystal Reports. I really liked this method because it didn't limit myself as the admin, CRD or the people who have a legitimate need to connect via ODBC.
Jason
On 9/5/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED] > wrote:
**
Tyrone:
Why do you want to do this? ODBC is required for Crystal to access the Remedy database. Is there a performance issue that needs to be addressed instead?
And, yes, I would like to know this too. It may involve shutting down the entire interface through the ar.cfg(ar.conf) file.
James Mckenzie
L-3 GSI
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of T. Dee
Sent: Tuesday, September 05, 2006 9:39 AM
To: arslist@ARSLIST.ORG
Subject: Question: Disable ODBC
I was wondring if someone could tell me what I can add to the AR.CFG file to disable users from using ODBC to connect to the server to run Crystal reports?
THANKS!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
