Check out user and group security at the database level. In addition, look
at authentication methods (i.e. client, server, etc.). You should be able
to secure the databases. I have MS Access users hitting my databases via
ODBC and I've secured the data down to the table level.

Good luck,
Blair

-----Original Message-----
From: Anthony Schmidt
[mailto:db2udbdba-ezmlmshield-x72007784.[Email address protected]
Sent: Thursday, March 24, 2005 2:46 PM
To: LazyDBA Discussion
Subject: MS Access and DB2


How do you protect your DB2 database from users who have tools like MS
Access?

Another way to ask this question is -

How can you prevent users from writing their own applications that can
Insert, Delete, Update, etc. in the database.

These users have the DB2 runtime client to run applications I've written,
but since DB2 security is based at the network OS level, there doesn't
appear to be a way to really protect the database.

I've only provided them with OLEDB connectivity, and for now it appears
that MS Access doesn't support that on DB2, so that's a stopgap measure
for now. But I'll bet MS Access will support DB2 on OLEDB in some future
release.

Tony

==============================
Anthony Schmidt
President
The Computery Ltd.
One East Main Street
Bay Shore, NY 11706

631-665-8100 Voice
631-969-5988 Fax

http://www.computeryltd.com


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


"Attention: This message is intended only for the individual to whom it is
addressed and may contain information that is confidential or privileged. If
you are not the intended recipient, or the employee or person responsible for
delivering it to the intended recipient, you are hereby notified that any
dissemination, distribution, copying or use is strictly prohibited. If you
have received this communication in error, please notify the sender and
destroy or delete this communication immediately."
==============================================================================

DB2 & UDB email list listserv db2-l LazyDBA home page