On 1/30/06, George Smith <[EMAIL PROTECTED]> wrote: > Phil, > I would have preferred that you would have said "In [UD] as opposed to > [UV]..." :) > Grs
Are you sure that you cannot do similarly with the SQL GRANT SELECT ... statement in UD? Are you currently doing a GRANT ALL? I haven't looked in a while, but in theory you should be able to use the SQL GRANT command to do what you want to do. --dawn > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of phil walker > Sent: Monday, January 30, 2006 2:49 PM > To: [email protected] > Subject: RE: [U2] SQL and Unidata Updates, Deletions > > 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: [email protected] > 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 > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > -- Dawn M. Wolthuis Tincat Group, Inc. Take and give some delight today! ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
