I had converted normal UV accounts to a schema for one client because it improved the access via ODBC/ADO. You could then access the data files externally as SQL tables or normally in UV. Just remember to grant 'public' sufficent access for the normal UV users to work.
You can do SQL statements in a UV account without doing any of this as someone else suggested. ---------Original Message---------- Now, if you are talking about *converting* the tables in question to SQL tables (which allows you to use constraints, but, as far as I can think of, that's the only benefit), you would probably want to make a complete copy of the data (or a subset adequate for testing/playing around with). Bob Woodward wrote: >So if I have an account and want to access the data from my SQLPLAY >account, how do I set this up so I can use SQL in SQLPLAY but not change >the other accounts access? Can I create VOC entries that point to the >same DATA files but have different DICT's? Is that enough? > > > >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:owner-u2- >>[EMAIL PROTECTED] On Behalf Of Richard Taylor >>Sent: Friday, February 04, 2005 10:22 AM >>To: u2-users@listserver.u2ug.org >>Subject: RE: [U2] Universe CREATE SCHEMA >> >>You are correct. I made an assumption regarding what he was doing. I >>know, I know assuming anything is not great practice. I humbly beg >>forgiveness from the group :) >> >> >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] On Behalf Of >>[EMAIL PROTECTED] >>Sent: Friday, February 04, 2005 11:02 AM >>To: u2-users@listserver.u2ug.org >>Subject: Re: [U2] Universe CREATE SCHEMA >> >>Richard Taylor wrote: >> >> >> >>>One other thing to watch out for is when you make an account into a >>> >>> >>Schema >> >> >>>normal, non-sql users, will not have access to the files anymore. If >>> >>> >you > > >>>want to use the account as a Schema and as a regular UV account you >>> >>> >can > > >>do >> >> >>>so but you will need to grant permissions to the non-sql defined >>> >>> >users. > > >>> >>> >>> >>This is only true if you *convert* an account to a schema. Merely >>creating a schema on an account does *NOT* convert existing files to >> >> >SQL > > >>tables. You will still be able to access your existing traditional >>Universe files as you always have. >>--- >>[This E-mail scanned for viruses by Declude Virus] >>------- >>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/ >> >> >------- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ >--- >[This E-mail scanned for viruses by Declude Virus] ------- 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/
