locked
Sysadmin role RRS feed

  • Question

  • Hi,

    I have beeon told:

    If i have sysadmin role, I become dbo on all databases ?

    Is it true ?

    Thanks for your help

     

     

    Sunday, November 6, 2011 9:13 AM

Answers

  • Hello,

    No, that's not correct. dbo = Database Owner is the user who created the database or who was definied to be the dbo.

    But for your permissions it doesn't matter, if you are a SysAdmin, you already have all permissions.


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing
    • Marked as answer by dududu_dudu Sunday, November 6, 2011 11:21 AM
    Sunday, November 6, 2011 11:19 AM

All replies

  • Hello,

    No, that's not correct. dbo = Database Owner is the user who created the database or who was definied to be the dbo.

    But for your permissions it doesn't matter, if you are a SysAdmin, you already have all permissions.


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing
    • Marked as answer by dududu_dudu Sunday, November 6, 2011 11:21 AM
    Sunday, November 6, 2011 11:19 AM
  • However, in each database a sysadmin operates, the sysadmin operates as the user dbo. For instance, a table created by a sysadmin will be owned by dbo.

    But technically, that is not the same thing as sysadmin owning the database.


    Tibor Karaszi, SQL Server MVP | web | blog
    Sunday, November 6, 2011 6:00 PM