I am rooting around in SQL Server Management Studio against my instance of SQL Server 2008 R2 Express Edition. I am trying to understand how the permissions work.
What I can see is (via the properties of many of these entities)
- My Server Login can be linked to a Database User
- My Database User can have one or more Database roles
- One of the Database Roles is db_datawriter which owns schema db_datawriter
However at that point the trail goes cold. Schema db_datawriter has a permissions page under its properties which is blank.
What defines precisely what schema db_datawriter's permissions are?