Post reply

public role

  • November 3, 2004 at 2:45 pm

    #86834

    Is the public role instance-wide or database-wide?

  • November 3, 2004 at 3:13 pm

    #528850

    laura,

    the public role is a database level role, every database user belongs to it and cannot be removed from it.  it provides access to all system level objects and exists in every system and user database. 

    it is configurable per database, but i would advise against ever modifying it's permissions, any database object permissions should be able to be managed via a combination of the built in database roles, custom db roles and application roles.

    have a look in BOL under Administering SQL Server>public Role for more info.

    ll

  • November 3, 2004 at 3:25 pm

    #528851

    thanks very much.  i'm attempting to build a case against modifying the permissions and wanted to make sure i understood the scope.  i appreciate your response!

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

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