Re: How do I share or change database ownership
From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 08/27/02
- Next message: Mark Johnson: "Linked Server to MS Access Database Using Mapped Drive"
- Previous message: Jasper Smith: "Re: MSDE login problems"
- In reply to: Rick Mullings: "How do I share or change database ownership"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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?
>
>
>
>
- Next message: Mark Johnson: "Linked Server to MS Access Database Using Mapped Drive"
- Previous message: Jasper Smith: "Re: MSDE login problems"
- In reply to: Rick Mullings: "How do I share or change database ownership"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]