Which user account to assign as owner when attaching an SQL Server database?
Posted
by FreshCode
on Stack Overflow
See other posts from Stack Overflow
or by FreshCode
Published on 2010-04-21T16:22:42Z
Indexed on
2010/04/21
16:23 UTC
Read the original article
Hit count: 205
This is a simple database security & performance question, but I've always used either a special user (eg. mydbuser
), or Windows' built-in NETWORK SECURITY
account as the owner when attaching databases to my SQL Server instances.
- When deploying my database to a production server, is there a specific user I should stick to or avoid? I would think that using an account with a set password could open the database up to a potential security issue.
© Stack Overflow or respective owner