RE: ODBC Security

["Warren, Rick" <RWarren@xxxxxxxxx>]

The system DSN has this same tab as does the user DSN and allows read only
access.  Typically I always set my DSN's up as system on my NT box.

Any DSN can be shared as long as the ODBC drivers on the different machines
are compatible.  An alternative is to use a DSN-less connection through
visual Basic.  More recent versions of Microsoft products are all shipped
with VBA (visual basic for applications) and should allow a DSN-less
connection to be established if desired.  This is a little more secure than
using a DSN because a person would have to go into the code to make a
change.

 

-----Original Message-----
From: Paul Holstein [mailto:holstein13@excite.com]
Sent: Friday, May 05, 2000 9:21 PM
To: BPCS-L@midrange.com
Subject: RE: ODBC Security


Rick,

What you are referring to is called a "User DSN" and as you correctly
pointed out, anyone can change it with very little effort.

To make things a bit more secure, I would set up a "System DSN" that is
shared accross the network and changed only by the system administrator.

--Paul Holstein
iWork Software, L.L.C.


On Fri, 5 May 2000 14:21:38 -0400 , BPCS-L@midrange.com wrote:

>  When setting up the ODBC DSN you can go to the tab marked 'Other' and
look
>  under connection type it gives you the option of setting the connection
to
>  READ ONLY.  If a user wants to change it and has access to the ODBC
>  administration program there is nothing to prevent them from making the
>  change though so it is not truly a security feature. 
>  
>  -----Original Message-----
>  From: Joel Kahsay [mailto:jkahsay@hotmail.com]
>  Sent: Friday, May 05, 2000 1:06 PM
>  To: BPCS-L@midrange.com
>  Subject: ODBC Security
>  
>  
>  Hi
>  
>  
>  how do you set read only security for a pc using ODBC to access files
>  in the AS400? Help
>  ________________________________________________________________________
>  Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>  
>  +---
>  | This is the BPCS Users Mailing List!
>  | To submit a new message, send your mail to BPCS-L@midrange.com.
>  | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>  | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>  | Questions should be directed to the list owner: dasmussen@aol.com
>  +---
>  +---
>  | This is the BPCS Users Mailing List!
>  | To submit a new message, send your mail to BPCS-L@midrange.com.
>  | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>  | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>  | Questions should be directed to the list owner: dasmussen@aol.com
>  +---





_______________________________________________________
Get 100% FREE Internet Access powered by Excite
Visit http://freelane.excite.com/freeisp

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---