[dbo].[kpi_exception_ack]
CREATE TABLE [dbo].[kpi_exception_ack]
(
[portal_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ack_date] [datetime] NOT NULL,
[kpi_exception_id] [binary] (17) NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XPKkpi_exception_ack] ON [dbo].[kpi_exception_ack] ([kpi_exception_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kpi_exception_ack_idx1] ON [dbo].[kpi_exception_ack] ([kpi_exception_id], [portal_user]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[kpi_exception_ack] TO [aionadmin_group]
GRANT INSERT ON [dbo].[kpi_exception_ack] TO [aionadmin_group]
GRANT DELETE ON [dbo].[kpi_exception_ack] TO [aionadmin_group]
GRANT UPDATE ON [dbo].[kpi_exception_ack] TO [aionadmin_group]
GO
