[dbo].[UEPDFDATA]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	0
Created	11:07:37 AM Wednesday, March 07, 2007
Last Modified	11:07:37 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
UECHECKEDOUT	int	4
UECHECKEDOUTTIME	datetime	8
UEDBID	int	4
UEMODTIME	datetime	8
UENUMEMPTYREQUIRED	int	4
UEPUBSTAGE	int	4
UEPUBTIME	datetime	8
UEAUTHOR	nvarchar(255)	510
UEBYTE_COUNT	int	4
UECREATED_BY	nvarchar(255)	510
UECREATION_DATE	datetime	8
UECREATOR	nvarchar(255)	510
UEDATE_EXPIRES	datetime	8
UEDESCRIPTION	nvarchar(1000)	2000
UEKEYWORDS	nvarchar(255)	510
UELAST_MODIFIED_BY	nvarchar(255)	510
UEMAJOR_TYPE	nvarchar(255)	510
UEMINOR_TYPE	nvarchar(255)	510
UENAME	nvarchar(255)	510
UEPARENTID	int	4
UEPDF_AUTHOR	nvarchar(255)	510
UEPDF_CREATION_DAT	datetime	8
UEPDF_KEYWORDS	nvarchar(255)	510
UEPDF_MODIFICATION	datetime	8
UEPDF_SUBJECT	nvarchar(255)	510
UEPDF_TITLE	nvarchar(255)	510
UEPRODUCER	nvarchar(255)	510
UESUBJECT	nvarchar(255)	510
UETITLE	nvarchar(255)	510
UEVERCOMMENT	nvarchar(1000)	2000
UEWORKFLOW_ID	int	4

Type	Action	Owning Principal
Grant	Delete	portaldba_group
Grant	Insert	portaldba_group
Grant	Delete	umpadmin
Grant	Insert	umpadmin
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	portaldba_group
Grant	Update	portaldba_group
Grant	Select	umpadmin
Grant	Update	umpadmin
Grant	Select	umpuser
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

SQL Script

CREATE TABLE [dbo].[UEPDFDATA]
(
[UECHECKEDOUT] [int] NULL,
[UECHECKEDOUTTIME] [datetime] NULL,
[UEDBID] [int] NOT NULL,
[UEMODTIME] [datetime] NULL,
[UENUMEMPTYREQUIRED] [int] NULL,
[UEPUBSTAGE] [int] NULL,
[UEPUBTIME] [datetime] NULL,
[UEAUTHOR] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEBYTE_COUNT] [int] NULL,
[UECREATED_BY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UECREATION_DATE] [datetime] NULL,
[UECREATOR] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEDATE_EXPIRES] [datetime] NULL,
[UEDESCRIPTION] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEKEYWORDS] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UELAST_MODIFIED_BY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEMAJOR_TYPE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEMINOR_TYPE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UENAME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEPARENTID] [int] NULL,
[UEPDF_AUTHOR] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEPDF_CREATION_DAT] [datetime] NULL,
[UEPDF_KEYWORDS] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEPDF_MODIFICATION] [datetime] NULL,
[UEPDF_SUBJECT] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEPDF_TITLE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEPRODUCER] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UESUBJECT] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UETITLE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEVERCOMMENT] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEWORKFLOW_ID] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[UEPDFDATA] TO [portaldba_group]
GRANT INSERT ON  [dbo].[UEPDFDATA] TO [portaldba_group]
GRANT DELETE ON  [dbo].[UEPDFDATA] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[UEPDFDATA] TO [portaldba_group]
GRANT SELECT ON  [dbo].[UEPDFDATA] TO [umpadmin]
GRANT INSERT ON  [dbo].[UEPDFDATA] TO [umpadmin]
GRANT DELETE ON  [dbo].[UEPDFDATA] TO [umpadmin]
GRANT UPDATE ON  [dbo].[UEPDFDATA] TO [umpadmin]
GRANT SELECT ON  [dbo].[UEPDFDATA] TO [umpuser]
GRANT SELECT ON  [dbo].[UEPDFDATA] TO [uniadmin]
GRANT INSERT ON  [dbo].[UEPDFDATA] TO [uniadmin]
GRANT DELETE ON  [dbo].[UEPDFDATA] TO [uniadmin]
GRANT UPDATE ON  [dbo].[UEPDFDATA] TO [uniadmin]
GRANT SELECT ON  [dbo].[UEPDFDATA] TO [uniuser]
GO