Tables [dbo].[pd_global]
Properties
PropertyValue
HeapYes
Row Count0
Created11:07:24 AM Wednesday, March 07, 2007
Last Modified11:09:41 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
major_versionint4
No
((1))
minor_versionint4
No
((0))
build_versionint4
No
((0))
revision_versionint4
No
((0))
Permissions
TypeActionOwning Principal
GrantDeletepdadmin
GrantInsertpdadmin
GrantDeleteuniadmin
GrantInsertuniadmin
GrantSelectpdadmin
GrantUpdatepdadmin
GrantSelectpduser
GrantSelectuniadmin
GrantUpdateuniadmin
SQL Script
CREATE TABLE [dbo].[pd_global]
(
[major_version] [int] NOT NULL CONSTRAINT [DF__pd_global__major__2784B8A3] DEFAULT ((1)),
[minor_version] [int] NOT NULL CONSTRAINT [DF__pd_global__minor__2878DCDC] DEFAULT ((0)),
[build_version] [int] NOT NULL CONSTRAINT [DF__pd_global__build__296D0115] DEFAULT ((0)),
[revision_version] [int] NOT NULL CONSTRAINT [DF__pd_global__revis__2A61254E] DEFAULT ((0))
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[pd_global] TO [pdadmin]
GRANT INSERT ON  [dbo].[pd_global] TO [pdadmin]
GRANT DELETE ON  [dbo].[pd_global] TO [pdadmin]
GRANT UPDATE ON  [dbo].[pd_global] TO [pdadmin]
GRANT SELECT ON  [dbo].[pd_global] TO [pduser]
GRANT SELECT ON  [dbo].[pd_global] TO [uniadmin]
GRANT INSERT ON  [dbo].[pd_global] TO [uniadmin]
GRANT DELETE ON  [dbo].[pd_global] TO [uniadmin]
GRANT UPDATE ON  [dbo].[pd_global] TO [uniadmin]
GO
Uses