RE: [U2] Universe CREATE SCHEMA
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. TypeGRANT ALL TO PUBLIC (I think I got the syntax right). If you want to limit some people create an SQL user for them and set more limited permissions. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Friday, February 04, 2005 1:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe CREATE SCHEMA You need to login as the administrator, which is the initial SQL User. Then GRANT Connect and then resources, etc to alternative users. Then you can logout and login under the new user and you will have SQL access rights. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, 4 February 2005 10:14 AM To: U2-Users List Subject: [U2] Universe CREATE SCHEMA Hi folks. I'm trying to get my feet wet with SQL and I've got what seems like a simple question to ask but one that is proving to be rather difficult to find an answer to. I'm wanting to issue a CREATE SCHEMA command but when I do I get an error message that I'm not an SQL user. How do I go about setting myself up as an SQL user? I'm logged into our domain and my UID is in the Administrators group so I should have rights to just about everything. The environment is Win2003 server, UV 10.1.3. I've searched FAQ's, PDF's, DOC's, websites, Google and still am having no luck finding anything that tells me how to set myself up as an SQL user. Any direction would be greatly appreciated. BobW --- 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/
Re: [U2] Universe CREATE SCHEMA
List UV_USERS to find the initially configured administrator user. On our system it is uvsql. I'm not sure if that is a standard or something that we setup. At any rate, if you haven't done anything with SQL, there should only be one user in there, but you are looking for someone with DBAuth privelege. Once logged in as this user, you should be able to grant CONNECT to whoever. See the Universe SQL reference (under the GRANT command) for details on priveleges required for different operations. Bob Woodward wrote: Hi folks. I'm trying to get my feet wet with SQL and I've got what seems like a simple question to ask but one that is proving to be rather difficult to find an answer to. I'm wanting to issue a CREATE SCHEMA command but when I do I get an error message that I'm not an SQL user. How do I go about setting myself up as an SQL user? I'm logged into our domain and my UID is in the Administrators group so I should have rights to just about everything. The environment is Win2003 server, UV 10.1.3. I've searched FAQ's, PDF's, DOC's, websites, Google and still am having no luck finding anything that tells me how to set myself up as an SQL user. Any direction would be greatly appreciated. BobW --- 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] --- [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/
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/
RE: [U2] Universe CREATE SCHEMA
Thanks to those that replied. I'd like to summarize the information and what I did. 1. While logged in to UV as my regular ID, I did a LIST UV_USERS which told me that the system was, in fact, installed by the Administrator user. 2. I logged out of UV then back in as the HWGDOM\administrator user and did a LOGTO UV. 3. Next I typed the following commands: GRANT CONNECT TO HWGDOM\bobw GRANT DBA TO HWGDOM\bobw 4. I logged out of UV then back in as my normal user id, bobw. 5. From my application account I was able to successfully issue the CREATE SCHEMA command. Again, thanks for you help, folks! BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, February 03, 2005 3:14 PM To: U2-Users List Subject: [U2] Universe CREATE SCHEMA Hi folks. I'm trying to get my feet wet with SQL and I've got what seems like a simple question to ask but one that is proving to be rather difficult to find an answer to. I'm wanting to issue a CREATE SCHEMA command but when I do I get an error message that I'm not an SQL user. How do I go about setting myself up as an SQL user? I'm logged into our domain and my UID is in the Administrators group so I should have rights to just about everything. The environment is Win2003 server, UV 10.1.3. I've searched FAQ's, PDF's, DOC's, websites, Google and still am having no luck finding anything that tells me how to set myself up as an SQL user. Any direction would be greatly appreciated. BobW --- 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/
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/
RE: [U2] Universe CREATE SCHEMA
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/
RE: [U2] Universe CREATE SCHEMA
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/
RE: [U2] Universe CREATE SCHEMA
You need to login as the administrator, which is the initial SQL User. Then GRANT Connect and then resources, etc to alternative users. Then you can logout and login under the new user and you will have SQL access rights. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, 4 February 2005 10:14 AM To: U2-Users List Subject: [U2] Universe CREATE SCHEMA Hi folks. I'm trying to get my feet wet with SQL and I've got what seems like a simple question to ask but one that is proving to be rather difficult to find an answer to. I'm wanting to issue a CREATE SCHEMA command but when I do I get an error message that I'm not an SQL user. How do I go about setting myself up as an SQL user? I'm logged into our domain and my UID is in the Administrators group so I should have rights to just about everything. The environment is Win2003 server, UV 10.1.3. I've searched FAQ's, PDF's, DOC's, websites, Google and still am having no luck finding anything that tells me how to set myself up as an SQL user. Any direction would be greatly appreciated. BobW --- 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/
