RE: ODBC Security

[Paul Holstein <holstein13@xxxxxxxxxx>]

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
+---