Sample Header Ad - 728x90

Can I change the owner of the cdc schema?

5 votes
2 answers
456 views
I've enabled Change Data Capture (CDC) on a database using exec sys.sp_cdc_enable_db This creates a new *cdc* schema which is owned by the *cdc* user
select
	s.*
    , dp.name
from sys.schemas as s
join sys.database_principals as dp
    on dp.principal_id = s.principal_id
enter image description here Because I want to leverage ownership chaining and read from this schema using a proc, can I change the owner to *dbo*?
ALTER AUTHORIZATION ON SCHEMA::cdc TO dbo
This command works and changes the owner. But the CDC has been enabled for a while, and I'm worried about breaking something further down the road.
Asked by Zikato (5724 rep)
Sep 8, 2023, 09:55 AM
Last activity: Sep 8, 2023, 05:50 PM