schemas created for roles and windows groups

  • well, looks like I flummoxed the SQL world again 🙂

    so I did some digging and testing:

    default database roles (db_accessadmin etc) are created with a schema, and although a new role create does not explicitly create a schema to go with it I can see the logic in a schema associated to a role, so I will leave these.

    windows groups - a schema is not explicitly created whn a windows group is added as a user to a database so I will drop these schemas unless the windows groups owns objects within the database, and is obviously fulfilling the role os a database 'role', if you see what I mean..........

    ---------------------------------------------------------------------

Viewing post 1 (of 2 total)

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