Public Server Role RRS feed

  • Question

  • Is the public server role the same as the database public role?  I assume it is different because it is a server role and not a database role.  Why is the name exactly the same as the database role?  That seems so confusing. 

    Why did it just start showing up in a service pack of 2005. 

    Why have I never heard it mentioned in a sql server 2005 book or mcitp test or study material?

    Why can't I find any info on it in 2005 books online?

    Tuesday, July 21, 2009 9:14 PM


  • I thik you already know the answer to these questions. As you guessed, this isn't the same as database public role. It was ineed added in a 2005 service pack, which would explain why documentation, tests etc might not mention it. FWIW, here is what Books Online for SQL Server 2008 has to say about the public server role:

    "Every SQL Server login belongs to the public server role. When a server principal has not been granted or denied specific permissions on a securable object, the user inherits the permissions granted to public on that object. Only assign public permissions on any object when you want the object to be available to all users."

    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Wednesday, July 22, 2009 5:33 AM