CREATE TABLE [dbo].[Roles]
(
[RoleID] [uniqueidentifier] NOT NULL,
[RoleName] [nvarchar] (260) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[Description] [nvarchar] (512) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[TaskMask] [nvarchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[RoleFlags] [tinyint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Roles] ADD CONSTRAINT [PK_Roles] PRIMARY KEY NONCLUSTERED ([RoleID]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_Roles] ON [dbo].[Roles] ([RoleName]) ON [PRIMARY]
GO
GRANT REFERENCES ON [dbo].[Roles] TO [RSExecRole]
GRANT SELECT ON [dbo].[Roles] TO [RSExecRole]
GRANT INSERT ON [dbo].[Roles] TO [RSExecRole]
GRANT DELETE ON [dbo].[Roles] TO [RSExecRole]
GRANT UPDATE ON [dbo].[Roles] TO [RSExecRole]
GO
[dbo].[Roles]
