CREATE TABLE [dbo].[al_user_ticket]
(
[ticket_id] [binary] (16) NOT NULL,
[user_id] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[first_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[roles] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[groups] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[application_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[expiration_time] [int] NOT NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__al_user_t__versi__28856082] DEFAULT ('0'),
[contact_uuid] [binary] (16) NULL,
[role_id] [int] NULL,
[tenant_read] [binary] (16) NULL,
[tenant_group_read] [binary] (16) NULL,
[tenant_write] [binary] (16) NULL,
[tenant_group_write] [binary] (16) NULL,
[update_public] [smallint] NULL,
[role_access] [smallint] NULL,
[user_access] [smallint] NULL,
[system_config_access] [smallint] NULL,
[reconciliation_access] [smallint] NULL,
[asset_fulfillment_access] [smallint] NULL,
[tou_accepted] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_user_ticket] ADD CONSTRAINT [PK_al_user_ticket] PRIMARY KEY CLUSTERED ([ticket_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[al_user_ticket] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[al_user_ticket] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[al_user_ticket] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[al_user_ticket] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[al_user_ticket] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[al_user_ticket] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_user_ticket] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_user_ticket] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_user_ticket] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_user_ticket] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_user_ticket] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_user_ticket] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_user_ticket] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_user_ticket] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_user_ticket] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_user_ticket] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_user_ticket] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_user_ticket] TO [uapmreporting_group]
GO