Tables [dbo].[Policies]
(local) > ReportServer > Tables > dbo.Policies
Properties
PropertyValue
Row Count3
Created12:33:31 PM Tuesday, March 06, 2007
Last Modified12:33:31 PM Tuesday, March 06, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_Policies: PolicyIDPolicyIDuniqueidentifier16
No
PolicyFlagtinyint1
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_Policies: PolicyIDPK_PoliciesPolicyID
Yes
Permissions
TypeActionOwning Principal
GrantDeleteRSExecRole
GrantInsertRSExecRole
GrantReferencesRSExecRole
GrantSelectRSExecRole
GrantUpdateRSExecRole
SQL Script
CREATE TABLE [dbo].[Policies]
(
[PolicyID] [uniqueidentifier] NOT NULL,
[PolicyFlag] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Policies] ADD CONSTRAINT [PK_Policies] PRIMARY KEY CLUSTERED ([PolicyID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Policies] TO [RSExecRole]
GRANT SELECT ON  [dbo].[Policies] TO [RSExecRole]
GRANT INSERT ON  [dbo].[Policies] TO [RSExecRole]
GRANT DELETE ON  [dbo].[Policies] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[Policies] TO [RSExecRole]
GO
Uses
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved