Tables [dbo].[UEWFACLDATA]
Properties
PropertyValue
HeapYes
Row Count0
Created11:07:38 AM Wednesday, March 07, 2007
Last Modified11:07:38 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
UEGROUPint4
Yes
UEPERMISSIONint4
Yes
UEPROCESSDEFIDint4
Yes
UEUSERint4
Yes
Permissions
TypeActionOwning Principal
GrantInsertuniadmin
GrantDeleteportaldba_group
GrantInsertportaldba_group
GrantDeleteumpadmin
GrantInsertumpadmin
GrantDeleteuniadmin
GrantSelectportaldba_group
GrantUpdateportaldba_group
GrantSelectumpadmin
GrantUpdateumpadmin
GrantSelectumpuser
GrantSelectuniadmin
GrantUpdateuniadmin
GrantSelectuniuser
SQL Script
CREATE TABLE [dbo].[UEWFACLDATA]
(
[UECHECKEDOUT] [int] NULL,
[UECHECKEDOUTTIME] [datetime] NULL,
[UEDBID] [int] NOT NULL,
[UEMODTIME] [datetime] NULL,
[UENUMEMPTYREQUIRED] [int] NULL,
[UEPUBSTAGE] [int] NULL,
[UEPUBTIME] [datetime] NULL,
[UEGROUP] [int] NULL,
[UEPERMISSION] [int] NULL,
[UEPROCESSDEFID] [int] NULL,
[UEUSER] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[UEWFACLDATA] TO [portaldba_group]
GRANT INSERT ON  [dbo].[UEWFACLDATA] TO [portaldba_group]
GRANT DELETE ON  [dbo].[UEWFACLDATA] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[UEWFACLDATA] TO [portaldba_group]
GRANT SELECT ON  [dbo].[UEWFACLDATA] TO [umpadmin]
GRANT INSERT ON  [dbo].[UEWFACLDATA] TO [umpadmin]
GRANT DELETE ON  [dbo].[UEWFACLDATA] TO [umpadmin]
GRANT UPDATE ON  [dbo].[UEWFACLDATA] TO [umpadmin]
GRANT SELECT ON  [dbo].[UEWFACLDATA] TO [umpuser]
GRANT SELECT ON  [dbo].[UEWFACLDATA] TO [uniadmin]
GRANT INSERT ON  [dbo].[UEWFACLDATA] TO [uniadmin]
GRANT DELETE ON  [dbo].[UEWFACLDATA] TO [uniadmin]
GRANT UPDATE ON  [dbo].[UEWFACLDATA] TO [uniadmin]
GRANT SELECT ON  [dbo].[UEWFACLDATA] TO [uniuser]
GO
Uses