April 24, 2007 at 1:31 am
Does it matter if sa, Domain/administrator or a different login (that an application will use) is set to db owner?
May 1, 2007 at 3:34 pm
If you don't mind the id having owner permissions on that database, I don't think it makes any difference.
June 28, 2007 at 5:08 am
An user with dbo rights on the database can perform any changes to the database you have to decide it on whether or not to give the permission for a user since that is a high level privilege within that database.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 28, 2007 at 6:50 am
I've always made it a practice to have the dbo set to SA, but for the most part it doesn't matter, as long as you're ok with whoever the owner is.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply