I don't know sybase, so what I suggest may not be possible, but can you
export all the objects into a spare database delete DBA and then
reimport.  Alternatively, create a new database that is set up as you
want and then inmport the objects.  As I said I never worked with Sybase
but this would work in the databases I have used, so maybe it is
possible in Sybase.

-----Original Message-----
From: Marilyn Li [mailto:rickymarilyn@s...]
Sent: Wednesday, February 28, 2001 10:08 AM
To: professional vb
Subject: [pro_vb] Re: ownership of tables in sybase database


I failed to create a GROUP with the creator name, DBA.  The error
message I
got is "A user or group named 'DBA' already exists, please choose
another
name."  I think this is because DBA was set up as the default user.  If
I
tried to delete the user DBA, then all objects will be also deleted.
Any
idea would be appreciated.

Marilyn