[dbo].[ca_link_named_config

Property	Value
Row Count	0
Created	11:07:58 AM Wednesday, March 07, 2007
Last Modified	9:08:03 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key XPKca_link_named_config_item: named_config_uuid\config_item_uuid\asset_uuid$	named_config_uuid	binary(16)	16
$Cluster Primary Key XPKca_link_named_config_item: named_config_uuid\config_item_uuid\asset_uuid$ $Foreign Keys $ca_li_r000003b400000000: [dbo].[ca_config_item].config_item_uuid\asset_uuid$	config_item_uuid	binary(16)	16
$Cluster Primary Key XPKca_link_named_config_item: named_config_uuid\config_item_uuid\asset_uuid$ $Foreign Keys $ca_li_r000003b400000000: [dbo].[ca_config_item].config_item_uuid\asset_uuid$	asset_uuid	binary(16)	16
	last_update_date	int	4
	version_number	int	4	((0))

	Name	Columns	Unique
$Cluster Primary Key XPKca_link_named_config_item: named_config_uuid\config_item_uuid\asset_uuid$	XPKca_link_named_config_item	named_config_uuid, config_item_uuid, asset_uuid

Name	Columns
$ca_li_r000003ab00000000	named_config_uuid->[dbo].[ca_named_configuration].[named_config_uuid]
$ca_li_r000003b400000000	config_item_uuid->[dbo].[ca_config_item].[config_item_uuid] asset_uuid->[dbo].[ca_config_item].[asset_uuid]

Type	Action	Owning Principal
Grant	Delete	ca_itrm_group
Grant	Insert	ca_itrm_group
Grant	Delete	ucmadmin
Grant	Insert	ucmadmin
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	regadmin
Grant	Select	ucmadmin
Grant	Update	ucmadmin
Grant	Select	ucmuser
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser
Grant	Select	upmuser_group
Grant	Select	ca_itrm_group_ams

SQL Script

CREATE TABLE [dbo].[ca_link_named_config_item]
(
[named_config_uuid] [binary] (16) NOT NULL,
[config_item_uuid] [binary] (16) NOT NULL,
[asset_uuid] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_link_n__versi__095F58DF] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_named_config_item] ADD CONSTRAINT [XPKca_link_named_config_item] PRIMARY KEY CLUSTERED ([named_config_uuid], [config_item_uuid], [asset_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_named_config_item] ADD CONSTRAINT [$ca_li_r000003ab00000000] FOREIGN KEY ([named_config_uuid]) REFERENCES [dbo].[ca_named_configuration] ([named_config_uuid])
GO
ALTER TABLE [dbo].[ca_link_named_config_item] ADD CONSTRAINT [$ca_li_r000003b400000000] FOREIGN KEY ([config_item_uuid], [asset_uuid]) REFERENCES [dbo].[ca_config_item] ([config_item_uuid], [asset_uuid])
GO
GRANT SELECT ON  [dbo].[ca_link_named_config_item] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_link_named_config_item] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_link_named_config_item] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_link_named_config_item] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_link_named_config_item] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_link_named_config_item] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_link_named_config_item] TO [ucmadmin]
GRANT INSERT ON  [dbo].[ca_link_named_config_item] TO [ucmadmin]
GRANT DELETE ON  [dbo].[ca_link_named_config_item] TO [ucmadmin]
GRANT UPDATE ON  [dbo].[ca_link_named_config_item] TO [ucmadmin]
GRANT SELECT ON  [dbo].[ca_link_named_config_item] TO [ucmuser]
GRANT SELECT ON  [dbo].[ca_link_named_config_item] TO [uniadmin]
GRANT INSERT ON  [dbo].[ca_link_named_config_item] TO [uniadmin]
GRANT DELETE ON  [dbo].[ca_link_named_config_item] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ca_link_named_config_item] TO [uniadmin]
GRANT SELECT ON  [dbo].[ca_link_named_config_item] TO [uniuser]
GRANT SELECT ON  [dbo].[ca_link_named_config_item] TO [upmuser_group]
GO