Why User Can Assume DBO When Created?

  • Oops.

    Learning something new on every visit to SSC. Hoping to pass it on to someone else.

  • Not sure if I understand the question, of if it was even meant to be a question.

    But a login maps do dbo in a database if:

    1) The login owns the database.

    2) The login is member of the fixed server role sysadmin.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply