sql server – Who should be an owner of the new schema? – Education Career Blog

I am creating a new schema in SQLServer 2008.

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

Should I use ‘dbo’ user as schema owner?

,

If all you want to do is make the name stand out, then just use dbo. No sense creating new users and roles that you don’t need.

But really, you shouldn’t create a schema just to do this. Why not simply prefix the names of the procedures?

,

From a security perspective the schema and all database objects should be owned by a role that cannot login yet has super user privileges. When maintenance is to be performed you login as a non-privileged user and set your role to the super user role.

Leave a Comment