none
sys user

    Question

  • hi all

    a newbee question:

    we have install a new 2008 R2 SQL Server and attach many 2005 DBs. Why is the user sys on every db disable on 2008 SQL Server.

     


    Chris
    Sunday, March 20, 2011 11:29 AM

Answers

  • Hi Tron,

    In SQL Server 2005 and above, there is a schema called sys which contains system tables/DMVs, etc. Each schema needs a user to own it, and the built in user that owns the sys schema is called sys. In short, it should be disabled, and is not an issue.


    Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/
    Sunday, March 20, 2011 2:26 PM
  • When ever you create any database by default we have four schemas are created(guest, dbo,information_schema and sys).

    Each schema needs to owned by a buit-in user with same name . You won't be able to delete them.

    Sunday, March 20, 2011 3:37 PM

All replies

  • Hi Tron,

    In SQL Server 2005 and above, there is a schema called sys which contains system tables/DMVs, etc. Each schema needs a user to own it, and the built in user that owns the sys schema is called sys. In short, it should be disabled, and is not an issue.


    Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/
    Sunday, March 20, 2011 2:26 PM
  • When ever you create any database by default we have four schemas are created(guest, dbo,information_schema and sys).

    Each schema needs to owned by a buit-in user with same name . You won't be able to delete them.

    Sunday, March 20, 2011 3:37 PM