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
Because I want to leverage ownership chaining and read from this schema using a proc, can I change the owner to *dbo*?
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

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
Last activity: Sep 8, 2023, 05:50 PM