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/
