Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Are there differences between Owned Schemas and Role Members?

From my understanding, the Role Members are compulsory - user need to have at least one of the check box under Role Members checked.

However, the Owned Schemas is not compulsory. It really make me wonder why there is a need to have the Owned Schemas in there.

enter image description here

share|improve this question
up vote 9 down vote accepted

Apples and Oranges. Roles are roles and schemas are schemas. The fact that there is a role called db_accessadmin and also a schema called db_accessadmin does not mean a role is a schema nor that a schema is a role. Roles are security membership containers, a principal is member of a role. Schemas contain database schema bound objects and are owned by a principal. When you create a new user you can choose his default schema, add him to certain roles, and grant him ownership of schemas. Although the actions are separate, the designers of this dialog feel they are somehow related as to merit all that UX real estate (that is questionable, but a completely different topic).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.