CREATE TABLE [dbo].[SecModules]
(
[ModulePriKey] [int] NOT NULL IDENTITY(1, 1),
[Description] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecModules] ADD CONSTRAINT [PK_SecModules] PRIMARY KEY CLUSTERED  ([ModulePriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_SecModules_Active] ON [dbo].[SecModules] ([Active], [Description]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_SecModules_Description] ON [dbo].[SecModules] ([Description]) INCLUDE ([Active]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[SecModules] TO [MssExec]
GRANT INSERT ON  [dbo].[SecModules] TO [MssExec]
GRANT DELETE ON  [dbo].[SecModules] TO [MssExec]
GRANT UPDATE ON  [dbo].[SecModules] TO [MssExec]
GO