[dbo].[ca_reg_intkeys]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	17
Created	11:07:05 AM Wednesday, March 07, 2007
Last Modified	11:09:06 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKca_reg_intkeys: intkeys_table\intkeys_column$	intkeys_table	varchar(33)	33
$Cluster Primary Key XPKca_reg_intkeys: intkeys_table\intkeys_column$	intkeys_column	varchar(33)	33
	intkeys_intkey	int	4
	intkeys_index	int	4
	intkeys_ipc_key	int	4
	intkeys_blocksize	int	4
	intkeys_ext1	int	4
	intkeys_ext2	int	4
	intkeys_smname	nvarchar(128)	256

	Name	Columns	Unique
$Cluster Primary Key XPKca_reg_intkeys: intkeys_table\intkeys_column$	XPKca_reg_intkeys	intkeys_table, intkeys_column

Type	Action	Owning Principal
Grant	Delete	regadmin
Grant	Insert	regadmin
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	References	regadmin
Grant	Select	regadmin
Grant	Update	regadmin
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Select	uapmadmin
Grant	Update	uapmadmin
Grant	Select	uapmbatch
Grant	Update	uapmbatch
Grant	Select	uapmreporting
Grant	Select	swcmadmin
Grant	Update	swcmadmin

SQL Script

CREATE TABLE [dbo].[ca_reg_intkeys]
(
[intkeys_table] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[intkeys_column] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[intkeys_intkey] [int] NULL,
[intkeys_index] [int] NULL,
[intkeys_ipc_key] [int] NULL,
[intkeys_blocksize] [int] NULL,
[intkeys_ext1] [int] NULL,
[intkeys_ext2] [int] NULL,
[intkeys_smname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_reg_intkeys] ADD CONSTRAINT [XPKca_reg_intkeys] PRIMARY KEY CLUSTERED ([intkeys_table], [intkeys_column]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[ca_reg_intkeys] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_reg_intkeys] TO [regadmin]
GRANT INSERT ON  [dbo].[ca_reg_intkeys] TO [regadmin]
GRANT DELETE ON  [dbo].[ca_reg_intkeys] TO [regadmin]
GRANT UPDATE ON  [dbo].[ca_reg_intkeys] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_reg_intkeys] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_reg_intkeys] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_reg_intkeys] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_reg_intkeys] TO [swcmadmin]
GRANT SELECT ON  [dbo].[ca_reg_intkeys] TO [uapmadmin]
GRANT INSERT ON  [dbo].[ca_reg_intkeys] TO [uapmadmin]
GRANT DELETE ON  [dbo].[ca_reg_intkeys] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[ca_reg_intkeys] TO [uapmadmin]
GRANT SELECT ON  [dbo].[ca_reg_intkeys] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[ca_reg_intkeys] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[ca_reg_intkeys] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[ca_reg_intkeys] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[ca_reg_intkeys] TO [uapmbatch]
GRANT INSERT ON  [dbo].[ca_reg_intkeys] TO [uapmbatch]
GRANT DELETE ON  [dbo].[ca_reg_intkeys] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[ca_reg_intkeys] TO [uapmbatch]
GRANT SELECT ON  [dbo].[ca_reg_intkeys] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[ca_reg_intkeys] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[ca_reg_intkeys] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[ca_reg_intkeys] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[ca_reg_intkeys] TO [uapmreporting]
GRANT SELECT ON  [dbo].[ca_reg_intkeys] TO [uapmreporting_group]
GO