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
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
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
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
, 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
-
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
: 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
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
]
[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