You have to HAVE DBA privilege before you can grant DBA privilege. To grant DBA privilege to Will.Johnson, you'll need to be logged in as OSP\Administrator (or any equivalent mapped in UV.LOGIN).
There is no such thing as a user called System. This "user" is the UniVerse Resource Service, which runs as a system process. ----- Original Message ----- From: [EMAIL PROTECTED] Date: Fri, 12 Mar 2004 15:15:02 -0500 To: [EMAIL PROTECTED] (U2 Users Discussion List) Subject: Re: Setting up SQL step 1 > I have a client who has never used SQL on their system and I'd like to set it up. > It is a Universe 10.0 on Windows setup. > > When I look at UV_Users I see two users one is NT Authority/System and the other is > OSP/administrator > > My first question is: > Is there really a windows login called System ? > Can a person log in as system? > > I have tried various ways to log in as administrator and cannot seem to let it GRANT > DBA to Will.Johnson > whenever I try it just complains that administrator is not an SQL user or something > like that. > > So what could be wrong? > Will > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
