Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

custom schema owner Expand / Collapse
Author
Message
Posted Wednesday, December 4, 2013 4:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:37 AM
Points: 290, Visits: 877
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?
Post #1519558
Posted Wednesday, December 4, 2013 4:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 6:59 AM
Points: 232, Visits: 159
Hi, you can use the same user that is db owner...
Post #1519560
Posted Wednesday, December 4, 2013 4:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:37 AM
Points: 290, Visits: 877
I always set the owner of the databases to sa, so we can do the same for the schemas?
Post #1519562
Posted Wednesday, December 4, 2013 5:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:10 AM
Points: 5,437, Visits: 10,129
The owner of the database is always mapped to the dbo user in the database.

ALTER AUTHORIZATION ON SCHEMA::MySchema TO dbo

John
Post #1519565
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse