CREATE TABLE [dbo].[ump_profiles]
(
[user_id] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[prop_name] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[prop_label] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[prop_selected] [nvarchar] (1500) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[prop_datatype] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[prop_value] [nvarchar] (1500) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[prop_description] [nvarchar] (1500) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[prop_unit] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[override] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[group_name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ump_profiles] TO [umpadmin]
GRANT INSERT ON  [dbo].[ump_profiles] TO [umpadmin]
GRANT DELETE ON  [dbo].[ump_profiles] TO [umpadmin]
GRANT UPDATE ON  [dbo].[ump_profiles] TO [umpadmin]
GRANT SELECT ON  [dbo].[ump_profiles] TO [umpuser]
GRANT SELECT ON  [dbo].[ump_profiles] TO [uniadmin]
GRANT INSERT ON  [dbo].[ump_profiles] TO [uniadmin]
GRANT DELETE ON  [dbo].[ump_profiles] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ump_profiles] TO [uniadmin]
GRANT SELECT ON  [dbo].[ump_profiles] TO [uniuser]
GO