Re: Who should be owner if bd?
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/21/04
- Next message: Sam: "Auditing a SQL user's Login activity"
- Previous message: Matthew: "Re: db_ddladmin role without 'drop' capability"
- In reply to: Laura: "Who should be owner if bd?"
- Next in thread: Dan Guzman: "Re: Who should be owner if bd?"
- Reply: Dan Guzman: "Re: Who should be owner if bd?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 21 Jul 2004 22:36:44 +0530
Hi,
It should not be a problem. Only thing is change the database owner (Use
sp_dbchangeowner)
incase the administrator drops/renames the nt login currently owns the
database.
Thanks
Hari
MCDBA
"Laura" <anonymous@discussions.microsoft.com> wrote in message
news:150901c46f31$01a8d920$a601280a@phx.gbl...
> I restored the databse on the SQL 2000 server and was
> logged in to the server under my NT account (it is an
> Admin account). Now the owner of the database is my NT
> account.
> Should the owner really be sa?
>
- Next message: Sam: "Auditing a SQL user's Login activity"
- Previous message: Matthew: "Re: db_ddladmin role without 'drop' capability"
- In reply to: Laura: "Who should be owner if bd?"
- Next in thread: Dan Guzman: "Re: Who should be owner if bd?"
- Reply: Dan Guzman: "Re: Who should be owner if bd?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
