CREATE TABLE [dbo].[urc_active_session]
(
[uid] [binary] (16) NOT NULL,
[uidparent] [binary] (16) NOT NULL,
[strhost] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[uidhost] [binary] (16) NOT NULL,
[uidsession] [binary] (16) NOT NULL,
[strviewer] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[datesessionstarted] [int] NOT NULL,
[iduration] [int] NOT NULL,
[strremoteuser] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[strstatus] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[strdescription] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[iseverity] [int] NOT NULL,
[iencryption] [int] NOT NULL,
[strprotocol] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[icategory] [int] NOT NULL,
[ieventid] [int] NOT NULL,
[ireasonsessionwasclosed] [int] NOT NULL,
[ifailsafe] [int] NOT NULL,
[host_uuid] [char] (36) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[urc_active_session] ADD CONSTRAINT [XPKurc_active_session] PRIMARY KEY CLUSTERED ([uid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [urc_active_session_i1] ON [dbo].[urc_active_session] ([datesessionstarted], [uid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [urc_active_session_i2] ON [dbo].[urc_active_session] ([uidparent], [iduration]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[urc_active_session] TO [ams_group]
GRANT SELECT ON  [dbo].[urc_active_session] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[urc_active_session] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[urc_active_session] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[urc_active_session] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[urc_active_session] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[urc_active_session] TO [upmuser_group]
GO