custom schema owner

  • So I have inherited a database with a few custom schemas - These are owned by a user who has sincle left the company.

    When dropping the user from the instance, what account is best place to own the schemas? And are there any implications in changing the owner?

  • Hi, you can use the same user that is db owner...

  • I always set the owner of the databases to sa, so we can do the same for the schemas?

  • The owner of the database is always mapped to the dbo user in the database.

    ALTER AUTHORIZATION ON SCHEMA::MySchema TO dbo

    John

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply