[dbo].[HARSTATEPROCESSACCESS]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	514
Created	5:00:11 AM Monday, March 02, 2009
Last Modified	5:00:28 AM Monday, March 02, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

514

Created

5:00:11 AM Monday, March 02, 2009

Last Modified

5:00:28 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key HARSTATEPROCESSACCESS_PK: STATEOBJID\PROCESSOBJID\USRGRPOBJID$ $Foreign Keys HARSTATEPROCACCESS_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PROCESSOBJID$	STATEOBJID	int	4
$Cluster Primary Key HARSTATEPROCESSACCESS_PK: STATEOBJID\PROCESSOBJID\USRGRPOBJID$ $Foreign Keys HARSTATEPROCACCESS_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PROCESSOBJID$ $Indexes HARSTATEPROCESSACCESS_PUE: PROCESSOBJID\USRGRPOBJID\EXECUTEACCESS$	PROCESSOBJID	int	4
$Cluster Primary Key HARSTATEPROCESSACCESS_PK: STATEOBJID\PROCESSOBJID\USRGRPOBJID$ $Indexes HARSTATEPROCESSACCESS_PUE: PROCESSOBJID\USRGRPOBJID\EXECUTEACCESS$	USRGRPOBJID	int	4
$Indexes HARSTATEPROCESSACCESS_PUE: PROCESSOBJID\USRGRPOBJID\EXECUTEACCESS$	EXECUTEACCESS	char(1)	1	('N')

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key HARSTATEPROCESSACCESS_PK: STATEOBJID\PROCESSOBJID\USRGRPOBJID$ $Foreign Keys HARSTATEPROCACCESS_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PROCESSOBJID$

STATEOBJID

int

$Cluster Primary Key HARSTATEPROCESSACCESS_PK: STATEOBJID\PROCESSOBJID\USRGRPOBJID$ $Foreign Keys HARSTATEPROCACCESS_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PROCESSOBJID$ $Indexes HARSTATEPROCESSACCESS_PUE: PROCESSOBJID\USRGRPOBJID\EXECUTEACCESS$

PROCESSOBJID

int

$Cluster Primary Key HARSTATEPROCESSACCESS_PK: STATEOBJID\PROCESSOBJID\USRGRPOBJID$

$Indexes HARSTATEPROCESSACCESS_PUE: PROCESSOBJID\USRGRPOBJID\EXECUTEACCESS$

USRGRPOBJID

int

$Indexes HARSTATEPROCESSACCESS_PUE: PROCESSOBJID\USRGRPOBJID\EXECUTEACCESS$

EXECUTEACCESS

char(1)

('N')

	Name	Columns	Unique
$Cluster Primary Key HARSTATEPROCESSACCESS_PK: STATEOBJID\PROCESSOBJID\USRGRPOBJID$	HARSTATEPROCESSACCESS_PK	STATEOBJID, PROCESSOBJID, USRGRPOBJID
	HARSTATEPROCESSACCESS_PUE	PROCESSOBJID, USRGRPOBJID, EXECUTEACCESS

Name

Columns

Unique

$Cluster Primary Key HARSTATEPROCESSACCESS_PK: STATEOBJID\PROCESSOBJID\USRGRPOBJID$

HARSTATEPROCESSACCESS_PK

STATEOBJID, PROCESSOBJID, USRGRPOBJID

HARSTATEPROCESSACCESS_PUE

PROCESSOBJID, USRGRPOBJID, EXECUTEACCESS

Name	Delete	Columns
HARSTATEPROCACCESS_SPID_FK	Cascade	STATEOBJID->[dbo].[HARSTATEPROCESS].[STATEOBJID] PROCESSOBJID->[dbo].[HARSTATEPROCESS].[PROCESSOBJID]
HARSTATEPROCACCESS_USRGRP_FK	Cascade	USRGRPOBJID->[dbo].[HARUSERGROUP].[USRGRPOBJID]

Name

Delete

Columns

HARSTATEPROCACCESS_SPID_FK

Cascade

STATEOBJID->[dbo].[HARSTATEPROCESS].[STATEOBJID]
PROCESSOBJID->[dbo].[HARSTATEPROCESS].[PROCESSOBJID]

HARSTATEPROCACCESS_USRGRP_FK

Cascade

USRGRPOBJID->[dbo].[HARUSERGROUP].[USRGRPOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARSTATEPROCESSACCESS table stores the definition of security for a CA SCM process.
Caption	COLUMN	EXECUTEACCESS	Execute access (Y/N)
Caption	COLUMN	PROCESSOBJID	Object ID of process
Caption	COLUMN	STATEOBJID	Object ID of state
Caption	COLUMN	USRGRPOBJID	Object ID of user group

Name

Level 2 Type

Level 2 Name

Value

Caption

The HARSTATEPROCESSACCESS table stores the definition of security for a CA SCM process.

Caption

COLUMN

EXECUTEACCESS

Execute access (Y/N)

Caption

COLUMN

PROCESSOBJID

Object ID of process

Caption

COLUMN

STATEOBJID

Object ID of state

Caption

COLUMN

USRGRPOBJID

Object ID of user group

SQL Script

CREATE TABLE [dbo].[HARSTATEPROCESSACCESS]
(
[STATEOBJID] [int] NOT NULL,
[PROCESSOBJID] [int] NOT NULL,
[USRGRPOBJID] [int] NOT NULL,
[EXECUTEACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARSTATEP__EXECU__7755B73D] DEFAULT ('N')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARSTATEPROCESSACCESS] ADD CONSTRAINT [HARSTATEPROCESSACCESS_PK] PRIMARY KEY CLUSTERED ([STATEOBJID], [PROCESSOBJID], [USRGRPOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARSTATEPROCESSACCESS_PUE] ON [dbo].[HARSTATEPROCESSACCESS] ([PROCESSOBJID], [USRGRPOBJID], [EXECUTEACCESS]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARSTATEPROCESSACCESS] ADD CONSTRAINT [HARSTATEPROCACCESS_SPID_FK] FOREIGN KEY ([STATEOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARSTATEPROCESS] ([STATEOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARSTATEPROCESSACCESS] ADD CONSTRAINT [HARSTATEPROCACCESS_USRGRP_FK] FOREIGN KEY ([USRGRPOBJID]) REFERENCES [dbo].[HARUSERGROUP] ([USRGRPOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARSTATEPROCESSACCESS table stores the definition of security for a CA SCM process.', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEPROCESSACCESS', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Execute access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEPROCESSACCESS', 'COLUMN', N'EXECUTEACCESS'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEPROCESSACCESS', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEPROCESSACCESS', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEPROCESSACCESS', 'COLUMN', N'USRGRPOBJID'
GO