Tables [dbo].[setting]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count3
Created11:07:30 AM Wednesday, March 07, 2007
Last Modified11:12:43 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key $setti_u000041de00000000: productid\actoractornvarchar(50)100
No
settingimagemax
No
Cluster Primary Key $setti_u000041de00000000: productid\actorproductidbinary(16)16
No
lastcheckinbigint8
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key $setti_u000041de00000000: productid\actor$setti_u000041de00000000productid, actor
Yes
Permissions
TypeActionOwning Principal
GrantDeleteservice_desk_admin_group
GrantInsertservice_desk_admin_group
GrantDeleteusmgroup
GrantInsertusmgroup
GrantDeleteworkflow_admin_group
GrantInsertworkflow_admin_group
GrantSelectservice_desk_admin_group
GrantUpdateservice_desk_admin_group
GrantSelectservice_desk_ro_group
GrantSelectusmgroup
GrantUpdateusmgroup
GrantSelectworkflow_admin_group
GrantUpdateworkflow_admin_group
GrantSelectworkflow_ro_group
SQL Script
CREATE TABLE [dbo].[setting]
(
[actor] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[setting] [image] NOT NULL,
[productid] [binary] (16) NOT NULL,
[lastcheckin] [bigint] NOT NULL CONSTRAINT [DF__setting__lastche__79F48ECB] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[setting] ADD CONSTRAINT [$setti_u000041de00000000] PRIMARY KEY CLUSTERED ([productid], [actor]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[setting] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[setting] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[setting] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[setting] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[setting] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[setting] TO [usmgroup]
GRANT INSERT ON  [dbo].[setting] TO [usmgroup]
GRANT DELETE ON  [dbo].[setting] TO [usmgroup]
GRANT UPDATE ON  [dbo].[setting] TO [usmgroup]
GRANT SELECT ON  [dbo].[setting] TO [workflow_admin_group]
GRANT INSERT ON  [dbo].[setting] TO [workflow_admin_group]
GRANT DELETE ON  [dbo].[setting] TO [workflow_admin_group]
GRANT UPDATE ON  [dbo].[setting] TO [workflow_admin_group]
GRANT SELECT ON  [dbo].[setting] TO [workflow_ro_group]
GO
Uses