SQL Server 2000 database owner question

microsoft.public.sqlserver.server

21 Nov 2007 8:15 AM

Jason Huang

Hi,

In my SQL Server 2000 Enterprise Manager, I have created a new Login account
JJ.
I also created a new database DBJ.
What do I need to do to make JJ the owner of the DBJ?
Thanks for help.

Jason

21 Nov 2007 8:47 AM

Uri Dimant

Jason
You don't have to , unless you want JJ to be owner.

Show quoteHide quote

"Jason Huang" <JasonHuang8***@hotmail.com> wrote in message
news:OdVZraBLIHA.5328@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> In my SQL Server 2000 Enterprise Manager, I have created a new Login
> account JJ.
> I also created a new database DBJ.
> What do I need to do to make JJ the owner of the DBJ?
> Thanks for help.
>
>
> Jason
>

Are all your drivers up to date? click for free checkup

21 Nov 2007 9:10 AM

Tibor Karaszi

Check out sp_changedbowner

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Show quoteHide quote

"Jason Huang" <JasonHuang8***@hotmail.com> wrote in message
news:OdVZraBLIHA.5328@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> In my SQL Server 2000 Enterprise Manager, I have created a new Login account JJ.
> I also created a new database DBJ.
> What do I need to do to make JJ the owner of the DBJ?
> Thanks for help.
>
>
> Jason
>

21 Nov 2007 9:28 AM

Adi

On Nov 21, 10:15 am, "Jason Huang" <JasonHuang8***@hotmail.com> wrote:
> Hi,
>
> In my SQL Server 2000 Enterprise Manager, I have created a new Login account
> JJ.
> I also created a new database DBJ.
> What do I need to do to make JJ the owner of the DBJ?
> Thanks for help.
>
> Jason

You can run sp_changedbowner to make JJ the owner of the database,
but most chances that there is no need to do that. You can just add
jj to db_owner role in the database and he'll have the same permission
as the database owner.

Adi