Strangely enough - I got both copies at the same time, but then again, I find it's not unusual to get an answer to a question before I get the question.
In answer to your query we did a similar thing recently. We setup an entire account with read only access for ODBC files. The files (VOC entries) had their own cleaned up dictionaries and pointed to the original data. We created select only views on these. We did this in UniData and it does SQL/ODBC differently, but you should be able to use the same technique of creating a new VOC file entry that points to the original file. hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 02, 2004 11:53 PM >To: [EMAIL PROTECTED] >Subject: [U2] [UV] CONVERT.SQL (UV files & SQL tables) > > >* Note: I'm resending this posting as after almost 3 hours my >first attempt >still hasn't appeared back in my inbox. >-------------------------------------- >Our UniVerse files on our production unix box all have >permissions set so >owner and group both have read & write access. >Our users are all locked into menus and can only access the >files via the >application programs. > >I would like to make one of these files accessible (SELECT only) to the >outside world via SQL. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
