Post reply

custom schema owner

  • December 4, 2013 at 4:25 am

    #279752

    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?

  • December 4, 2013 at 4:48 am

    #1670655

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

  • December 4, 2013 at 4:51 am

    #1670657

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

  • December 4, 2013 at 5:07 am

    #1670660

    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