I'm looking to create a new schema for an existing database, which currently only uses the
dbo schema. I'm after advice on how to set the
AUTHORIZATION (owner name) and what affect this will have.
1. Should I create a new user for this or can I use the
I notice the existing
Database Roles in the database are owned by the
2. If I set the
AUTHORIZATION to a new user will I need to create new
Database Roles owned by the new user?
I've also noticed the
Default schema for existing
Users is the
3. Will I need to create new
Users with a default schema set to the new schema?
My main reason for creating the new schema is to separate the database objects by name rather than for permissions. I intend on granting certain existing
Users access to specific database procedures on the new schema as we do for database procedures on the dbo schema.