Re: How do I share or change database ownership

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 08/27/02


From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Tue, 27 Aug 2002 20:10:54 +0100


You can add them to the db_ddladmin or db_owner
fixed database roles.

HTH
Jasper Smith

"Rick Mullings" <rickmullings@hotmail.com> wrote in message
news:1030464249.649895@gaspra.spiretech.com...
> NuMedics Inc.
> Rick Mullings
>
> I am having some problems with granting ALTER table rights to a new user.
I
> was told that only the owner of the database can ALTER tables. So my
> question is, how do I change or share the ownership from SYSDBA to the
newly
> created user. Is this possible?
>
>
>
>