
[dbo].[ca_link_contact_user]
CREATE TABLE [dbo].[ca_link_contact_user]
(
[user_uuid] [binary] (16) NOT NULL,
[contact_uuid] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_link_c__versi__6EAB62A3] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_contact_user] ADD CONSTRAINT [XPKca_link_contact_user] PRIMARY KEY CLUSTERED ([contact_uuid], [user_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_contact_user] ADD CONSTRAINT [$ca_li_r0000035400000000] FOREIGN KEY ([contact_uuid]) REFERENCES [dbo].[ca_contact] ([contact_uuid])
GO
ALTER TABLE [dbo].[ca_link_contact_user] ADD CONSTRAINT [$ca_li_r0000035d00000000] FOREIGN KEY ([user_uuid]) REFERENCES [dbo].[ca_discovered_user] ([user_uuid])
GO
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [ca_itrm_group]
GRANT INSERT ON [dbo].[ca_link_contact_user] TO [ca_itrm_group]
GRANT DELETE ON [dbo].[ca_link_contact_user] TO [ca_itrm_group]
GRANT UPDATE ON [dbo].[ca_link_contact_user] TO [ca_itrm_group]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [ca_itrm_group_ams]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [regadmin]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [swcmadmin]
GRANT INSERT ON [dbo].[ca_link_contact_user] TO [swcmadmin]
GRANT DELETE ON [dbo].[ca_link_contact_user] TO [swcmadmin]
GRANT UPDATE ON [dbo].[ca_link_contact_user] TO [swcmadmin]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [uapmadmin]
GRANT INSERT ON [dbo].[ca_link_contact_user] TO [uapmadmin]
GRANT DELETE ON [dbo].[ca_link_contact_user] TO [uapmadmin]
GRANT UPDATE ON [dbo].[ca_link_contact_user] TO [uapmadmin]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [uapmadmin_group]
GRANT INSERT ON [dbo].[ca_link_contact_user] TO [uapmadmin_group]
GRANT DELETE ON [dbo].[ca_link_contact_user] TO [uapmadmin_group]
GRANT UPDATE ON [dbo].[ca_link_contact_user] TO [uapmadmin_group]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [uapmbatch]
GRANT INSERT ON [dbo].[ca_link_contact_user] TO [uapmbatch]
GRANT DELETE ON [dbo].[ca_link_contact_user] TO [uapmbatch]
GRANT UPDATE ON [dbo].[ca_link_contact_user] TO [uapmbatch]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [uapmbatch_group]
GRANT INSERT ON [dbo].[ca_link_contact_user] TO [uapmbatch_group]
GRANT DELETE ON [dbo].[ca_link_contact_user] TO [uapmbatch_group]
GRANT UPDATE ON [dbo].[ca_link_contact_user] TO [uapmbatch_group]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [uapmreporting]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [uapmreporting_group]
GRANT SELECT ON [dbo].[ca_link_contact_user] TO [upmuser_group]
GO