Yeah...the frustrating part (for me anyways) is managing the privileges. Try on the views, hopefully that will doit. Or...what we've ended up doing....is generating the schema as a generic user (we created a unix account called sqlmgr) then when we deliver an access database, the password is saved. Anyone creating queries will login via odbc as sqlmgr.
Just so you know, if you wish to do that now, I believe you'll need to cleanup the schema then regenerate as the generic user (so everything's owned by the same person). I'm not sure how you do that in vsg...i don't have it loaded right now. But...there's probably an option to do so? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Tuesday, November 23, 2004 7:01 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Unidata Odbc Thanks Amy. I was granting Select to Public on the SQL tables , but not on the views maybe that could help. The consultant is pointing his ERWIN tool at MS access ,to show the columns. -----Original Message----- ######################################################################## ############# This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ######################################################################## ############# ************************************************************************ **************************************************** CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. ************************************************************************ **************************************************** ------- 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/