When I create a database and add a user I get an interface with options. On that interface I can choose:
- Owned Schemas
- Membership
This question on dba.stackexchange HERE says schemas and roles are not related. This has confused me in the past since they have the same names. Why is this?
Also. In the Schemas
folder, I see dbo
, INFORMATION_SCHEMA
, and sys
. But in the user dialogue, under 'Owned Schemas' I don't see these options. Why is this?