Who should be the owner of the new scheme?

I am creating a new schema in SQLServer 2008.

Should I create a new user with the same name as the schema owner?

Should I use user "dbo" as the owner of the schema?

+4
source share
2 answers

If you want to do this, highlight the name and then just use dbo. It makes no sense to create new users and roles that you do not need.

But in fact, you should not create a circuit just for this. Why not just prefix the procedure names?

+2
source

From a security point of view, the schema and all database objects must belong to a role that cannot log into the system but has superuser privileges. When maintenance is due, you log in as a non-privileged user and set your role to the superuser role.

+2
source

All Articles