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

Related posts about database-connection

Related posts about sql-server