In [UV] as opposed to [UD] you can grant SQL SELECT privilege and not INSERT, UPDATE or DELETE privileges.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Smith Sent: Tuesday, 31 January 2006 9:16 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] SQL and Unidata Updates, Deletions How do you prevent in Unidata someone from using SQL to update (or delete) your Unidata data while at the same time allow them the ability to read the data with such tools as Excel and/ or Crystal Reports. Thanks George R Smith Programmer / Analyst 479.684.3382 direct 479.684.3403 fax www.budgetext.com <http://www.budgetext.com/> CONFIDENTIALITY NOTICE: The materials in this electronic mail transmission (including all attachments) are private and confidential and are the property of the sender. The information contained in the material is privileged and is intended only for the use of the named addressee(s). If you are not the intended addressee, be advised that any unauthorized disclosure, copying, distribution or the taking of any action in reliance on the contents of this material is strictly prohibited. If you received this electronic mail message in error, please immediately notify the sender by telephone at 888-869-0366 or send an electronic message to [EMAIL PROTECTED], and thereafter, destroy the electronic message immediately. [demime 1.01d removed an attachment of type image/gif which had a name of image001.gif] ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/