Tables [dbo].[UEWFPROCESSDEFDATA]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created11:07:39 AM Wednesday, March 07, 2007
Last Modified11:07:39 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
UECHECKEDOUTint4
Yes
UECHECKEDOUTTIMEdatetime8
Yes
UEDBIDint4
No
UEMODTIMEdatetime8
Yes
UENUMEMPTYREQUIREDint4
Yes
UEPUBSTAGEint4
Yes
UEPUBTIMEdatetime8
Yes
UEACTVnvarchar(4000)8000
Yes
UEATTRnvarchar(4000)8000
Yes
UEDESCnvarchar(1000)2000
Yes
UENAMEnvarchar(255)510
Yes
UESTATEbit1
Yes
UESUBJECTnvarchar(255)510
Yes
Permissions
TypeActionOwning Principal
GrantDeleteportaldba_group
GrantInsertportaldba_group
GrantDeleteumpadmin
GrantInsertumpadmin
GrantDeleteuniadmin
GrantInsertuniadmin
GrantSelectportaldba_group
GrantUpdateportaldba_group
GrantSelectumpadmin
GrantUpdateumpadmin
GrantSelectumpuser
GrantSelectuniadmin
GrantUpdateuniadmin
GrantSelectuniuser
SQL Script
CREATE TABLE [dbo].[UEWFPROCESSDEFDATA]
(
[UECHECKEDOUT] [int] NULL,
[UECHECKEDOUTTIME] [datetime] NULL,
[UEDBID] [int] NOT NULL,
[UEMODTIME] [datetime] NULL,
[UENUMEMPTYREQUIRED] [int] NULL,
[UEPUBSTAGE] [int] NULL,
[UEPUBTIME] [datetime] NULL,
[UEACTV] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEATTR] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEDESC] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UENAME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UESTATE] [bit] NULL,
[UESUBJECT] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[UEWFPROCESSDEFDATA] TO [portaldba_group]
GRANT INSERT ON  [dbo].[UEWFPROCESSDEFDATA] TO [portaldba_group]
GRANT DELETE ON  [dbo].[UEWFPROCESSDEFDATA] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[UEWFPROCESSDEFDATA] TO [portaldba_group]
GRANT SELECT ON  [dbo].[UEWFPROCESSDEFDATA] TO [umpadmin]
GRANT INSERT ON  [dbo].[UEWFPROCESSDEFDATA] TO [umpadmin]
GRANT DELETE ON  [dbo].[UEWFPROCESSDEFDATA] TO [umpadmin]
GRANT UPDATE ON  [dbo].[UEWFPROCESSDEFDATA] TO [umpadmin]
GRANT SELECT ON  [dbo].[UEWFPROCESSDEFDATA] TO [umpuser]
GRANT SELECT ON  [dbo].[UEWFPROCESSDEFDATA] TO [uniadmin]
GRANT INSERT ON  [dbo].[UEWFPROCESSDEFDATA] TO [uniadmin]
GRANT DELETE ON  [dbo].[UEWFPROCESSDEFDATA] TO [uniadmin]
GRANT UPDATE ON  [dbo].[UEWFPROCESSDEFDATA] TO [uniadmin]
GRANT SELECT ON  [dbo].[UEWFPROCESSDEFDATA] TO [uniuser]
GO
Uses