[dbo].[al_report

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	25
Created	2:24:49 PM Friday, March 21, 2008
Last Modified	2:46:46 PM Saturday, July 19, 2008

Name	Data Type	Max Length (Bytes)
report_id	int	4
name	nvarchar(255)	510
path	nvarchar(500)	1000
height	int	4
width	int	4

	Name	Columns	Unique
	PK_al_report_def	report_id
	al_al_report_def_index_1	name

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

SQL Script

CREATE TABLE [dbo].[al_report_def]
(
[report_id] [int] NOT NULL,
[name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[path] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[height] [int] NULL,
[width] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_report_def] ADD CONSTRAINT [PK_al_report_def] PRIMARY KEY CLUSTERED ([report_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [al_al_report_def_index_1] ON [dbo].[al_report_def] ([name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[al_report_def] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_report_def] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_report_def] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_report_def] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_report_def] TO [uapmadmin]
GRANT INSERT ON  [dbo].[al_report_def] TO [uapmadmin]
GRANT DELETE ON  [dbo].[al_report_def] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[al_report_def] TO [uapmadmin]
GRANT SELECT ON  [dbo].[al_report_def] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_report_def] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_report_def] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_report_def] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_report_def] TO [uapmbatch]
GRANT INSERT ON  [dbo].[al_report_def] TO [uapmbatch]
GRANT DELETE ON  [dbo].[al_report_def] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[al_report_def] TO [uapmbatch]
GRANT SELECT ON  [dbo].[al_report_def] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_report_def] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_report_def] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_report_def] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_report_def] TO [uapmreporting]
GRANT INSERT ON  [dbo].[al_report_def] TO [uapmreporting]
GRANT DELETE ON  [dbo].[al_report_def] TO [uapmreporting]
GRANT UPDATE ON  [dbo].[al_report_def] TO [uapmreporting]
GRANT SELECT ON  [dbo].[al_report_def] TO [uapmreporting_group]
GRANT INSERT ON  [dbo].[al_report_def] TO [uapmreporting_group]
GRANT DELETE ON  [dbo].[al_report_def] TO [uapmreporting_group]
GRANT UPDATE ON  [dbo].[al_report_def] TO [uapmreporting_group]
GO