[dbo].[policonf]

Property	Value
Row Count	0
Created	11:07:25 AM Wednesday, March 07, 2007
Last Modified	11:09:11 AM Wednesday, March 07, 2007

Property

Value

Row Count

Created

11:07:25 AM Wednesday, March 07, 2007

Last Modified

11:09:11 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKpoliconf: polid\poltype\pdomid$	pdomid	int	4
$Cluster Primary Key XPKpoliconf: polid\poltype\pdomid$	polid	int	4
$Cluster Primary Key XPKpoliconf: polid\poltype\pdomid$	poltype	int	4
	qdomid	int	4
	polqid	int	4
	polinter	int	4
	edomid	int	4
	polengid	int	4
	auto_rep_version	timestamp	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKpoliconf: polid\poltype\pdomid$

pdomid

int

$Cluster Primary Key XPKpoliconf: polid\poltype\pdomid$

polid

int

$Cluster Primary Key XPKpoliconf: polid\poltype\pdomid$

poltype

int

qdomid

int

polqid

int

polinter

int

edomid

int

polengid

int

auto_rep_version

timestamp

	Name	Columns	Unique
$Cluster Primary Key XPKpoliconf: polid\poltype\pdomid$	XPKpoliconf	polid, poltype, pdomid

Name

Columns

Unique

$Cluster Primary Key XPKpoliconf: polid\poltype\pdomid$

XPKpoliconf

polid, poltype, pdomid

Type	Action	Owning Principal
Grant	Delete	ca_itrm_group
Grant	Insert	ca_itrm_group
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	upmuser_group
Grant	Select	ca_itrm_group_ams
Grant	Select	ams_group

Type

Action

Owning Principal

Grant

Delete

ca_itrm_group

Grant

Insert

ca_itrm_group

Grant

Select

ca_itrm_group

Grant

Update

ca_itrm_group

Grant

Select

upmuser_group

Grant

Select

ca_itrm_group_ams

Grant

Select

ams_group

SQL Script

CREATE TABLE [dbo].[policonf]
(
[pdomid] [int] NOT NULL,
[polid] [int] NOT NULL,
[poltype] [int] NOT NULL,
[qdomid] [int] NULL,
[polqid] [int] NULL,
[polinter] [int] NULL,
[edomid] [int] NULL,
[polengid] [int] NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[policonf] ADD CONSTRAINT [XPKpoliconf] PRIMARY KEY CLUSTERED ([polid], [poltype], [pdomid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[policonf] TO [ams_group]
GRANT SELECT ON  [dbo].[policonf] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[policonf] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[policonf] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[policonf] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[policonf] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[policonf] TO [upmuser_group]
GO