Add owner reference to the resources made by rotator to delete them when read replica resources are deleted

Add owner reference to the resources made by rotator to delete them when read replica resources are deleted #10047