[dbo].[eccm

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

Property

Value

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKeccm_user: eccmuserid\userid$	eccmuserid	int	4
$Cluster Primary Key XPKeccm_user: eccmuserid\userid$	userid	int	4
	eccm_configurationid	int	4
	datetime_updated	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKeccm_user: eccmuserid\userid$

eccmuserid

int

$Cluster Primary Key XPKeccm_user: eccmuserid\userid$

userid

int

eccm_configurationid

int

datetime_updated

datetime

	Name	Columns	Unique
$Cluster Primary Key XPKeccm_user: eccmuserid\userid$	XPKeccm_user	eccmuserid, userid

Name

Columns

Unique

$Cluster Primary Key XPKeccm_user: eccmuserid\userid$

XPKeccm_user

eccmuserid, userid

Type	Action	Owning Principal
Grant	Delete	cmew_admin
Grant	Insert	cmew_admin
Grant	Select	cmew_admin
Grant	Update	cmew_admin
Grant	Select	cmew_rdr

Type

Action

Owning Principal

Grant

Delete

cmew_admin

Grant

Insert

cmew_admin

Grant

Select

cmew_admin

Grant

Update

cmew_admin

Grant

Select

cmew_rdr

SQL Script

CREATE TABLE [dbo].[eccm_user]
(
[eccmuserid] [int] NOT NULL,
[userid] [int] NOT NULL,
[eccm_configurationid] [int] NOT NULL,
[datetime_updated] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[eccm_user] ADD CONSTRAINT [XPKeccm_user] PRIMARY KEY CLUSTERED ([eccmuserid], [userid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[eccm_user] TO [cmew_admin]
GRANT INSERT ON  [dbo].[eccm_user] TO [cmew_admin]
GRANT DELETE ON  [dbo].[eccm_user] TO [cmew_admin]
GRANT UPDATE ON  [dbo].[eccm_user] TO [cmew_admin]
GRANT SELECT ON  [dbo].[eccm_user] TO [cmew_rdr]
GO