0

What is the best account for dbo user? I mean that if I use personal AD account for database owner, and if this account is removed from AD (e.g if I leave my job), these databases are not accessible. I have heard that there is also problems using "sa" account in dbo.

jrara
  • 209
  • 2
  • 6
  • 14

2 Answers2

1

Create a separate account for that, something like SQLadmin. Give it only the permissions it needs in AD, and whatever it needs for SQL.

KCotreau
  • 3,381
  • 3
  • 20
  • 24
0

dbo is a "user" (a security principal at the database level) and is listed in sys.database_principals

It isn't the database owner mentioned in sys.databases.owner_sid. This column is at the server level and matches an entry in sys.server_principals, specifically the sid column.

For ease of use, just make the owner sa. There are no major issues with doing this.

gbn
  • 6,079
  • 1
  • 18
  • 21