CREATE TABLE [dbo].[usm_acl]
(
[acl_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[create_permit] [int] NULL CONSTRAINT [DF__usm_acl__create___77E09279] DEFAULT ('0'),
[delete_permit] [int] NULL CONSTRAINT [DF__usm_acl__delete___78D4B6B2] DEFAULT ('0'),
[domain] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[modify_permit] [int] NULL CONSTRAINT [DF__usm_acl__modify___79C8DAEB] DEFAULT ('0'),
[read_permit] [int] NULL CONSTRAINT [DF__usm_acl__read_pe__7ABCFF24] DEFAULT ('0'),
[execute_permit] [int] NULL CONSTRAINT [DF__usm_acl__execute__7BB1235D] DEFAULT ('0'),
[mod_permit] [int] NULL CONSTRAINT [DF__usm_acl__mod_per__7CA54796] DEFAULT ('0'),
[list_permit] [int] NULL CONSTRAINT [DF__usm_acl__list_pe__7D996BCF] DEFAULT ('0'),
[is_system] [tinyint] NULL CONSTRAINT [DF__usm_acl__is_syst__7E8D9008] DEFAULT ('0'),
[description] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[roles] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[usm_acl] ADD CONSTRAINT [XPKusm_acl] PRIMARY KEY CLUSTERED ([acl_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_acl] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_acl] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_acl] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_acl] TO [usmgroup]
GO