[dbo].[HARENVIRONMENTACCESS]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	29
Created	4:59:42 AM Monday, March 02, 2009
Last Modified	5:00:26 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key HARENVACCESS_PK: ENVOBJID\USRGRPOBJID$	ENVOBJID	int	4
$Cluster Primary Key HARENVACCESS_PK: ENVOBJID\USRGRPOBJID$	USRGRPOBJID	int	4
	SECUREACCESS	char(1)	1	('N')
	UPDATEACCESS	char(1)	1	('N')
	VIEWACCESS	char(1)	1	('N')
	EXECUTEACCESS	char(1)	1	('N')

	Name	Columns	Unique
$Cluster Primary Key HARENVACCESS_PK: ENVOBJID\USRGRPOBJID$	HARENVACCESS_PK	ENVOBJID, USRGRPOBJID

Name	Delete	Columns
HARENVACCESS_ENVID_FK	Cascade	ENVOBJID->[dbo].[HARENVIRONMENT].[ENVOBJID]
HARENVACCESS_USRGRPID_FK	Cascade	USRGRPOBJID->[dbo].[HARUSERGROUP].[USRGRPOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARENVIRONMENTACCESS table controls CA SCM environment security.
Caption	COLUMN	ENVOBJID	Object ID of project
Caption	COLUMN	EXECUTEACCESS	Execute access (Y/N)
Caption	COLUMN	SECUREACCESS	Secure access (Y/N)
Caption	COLUMN	UPDATEACCESS	Update access (Y/N)
Caption	COLUMN	USRGRPOBJID	Object ID of user group
Caption	COLUMN	VIEWACCESS	View access (Y/N)

SQL Script

CREATE TABLE [dbo].[HARENVIRONMENTACCESS]
(
[ENVOBJID] [int] NOT NULL,
[USRGRPOBJID] [int] NOT NULL,
[SECUREACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARENVIRO__SECUR__3B75D760] DEFAULT ('N'),
[UPDATEACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARENVIRO__UPDAT__3C69FB99] DEFAULT ('N'),
[VIEWACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARENVIRO__VIEWA__3D5E1FD2] DEFAULT ('N'),
[EXECUTEACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARENVIRO__EXECU__3E52440B] DEFAULT ('N')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARENVIRONMENTACCESS] ADD CONSTRAINT [HARENVACCESS_PK] PRIMARY KEY CLUSTERED ([ENVOBJID], [USRGRPOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARENVIRONMENTACCESS] ADD CONSTRAINT [HARENVACCESS_ENVID_FK] FOREIGN KEY ([ENVOBJID]) REFERENCES [dbo].[HARENVIRONMENT] ([ENVOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARENVIRONMENTACCESS] ADD CONSTRAINT [HARENVACCESS_USRGRPID_FK] FOREIGN KEY ([USRGRPOBJID]) REFERENCES [dbo].[HARUSERGROUP] ([USRGRPOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARENVIRONMENTACCESS table controls CA SCM environment security.', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENTACCESS', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of project', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENTACCESS', 'COLUMN', N'ENVOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Execute access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENTACCESS', 'COLUMN', N'EXECUTEACCESS'
GO
EXEC sp_addextendedproperty N'Caption', N'Secure access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENTACCESS', 'COLUMN', N'SECUREACCESS'
GO
EXEC sp_addextendedproperty N'Caption', N'Update access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENTACCESS', 'COLUMN', N'UPDATEACCESS'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENTACCESS', 'COLUMN', N'USRGRPOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'View access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENTACCESS', 'COLUMN', N'VIEWACCESS'
GO