April 21, 2006 at 12:04 pm
Is it a good idea to have sa as dbo user always. Or we can have another user with sysadmin role be the dbo.
Also, is it important that login with sysadmin rights be always the dbo. What if a login with db_creator server role is the dbo? Does that create any problems?
Please reply. I'd appreciate.
Regards, Madiha.
April 24, 2006 at 8:00 am
This was removed by the editor as SPAM
April 24, 2006 at 10:46 am
There are a number of ways you can handle this - there are some whitepapers about this - you might like to check out http://www.sqlsecurity.com/
My preference would be to either allow or dissallow sa - no half way. Any account can be sysadmin, you can remove other accounts.
only allow dbo for those users who need it, likewise dbcreators. It would be rather pointless to not allow the sysadmin to be dbo though.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply