CREATE TABLE [dbo].[ud_datasource_list]
(
[dsschema] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[dsserver] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[dsuser] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[dspwd] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[dsengine] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[dsdbname] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[lactdate] [datetime] NOT NULL CONSTRAINT [DF__ud_dataso__lactd__379CBB89] DEFAULT (' '),
[createdate] [datetime] NOT NULL CONSTRAINT [DF__ud_dataso__creat__3890DFC2] DEFAULT (' '),
[dssourceid] [int] NULL,
[dssourceuuid] [uniqueidentifier] NULL,
[dsport] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[iproduct] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [ud_datasource_list_ak2] ON [dbo].[ud_datasource_list] ([dsdbname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ud_datasource_list_ak3] ON [dbo].[ud_datasource_list] ([dsengine]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ud_datasource_list_ak1] ON [dbo].[ud_datasource_list] ([dsserver]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ud_datasource_list_ak5] ON [dbo].[ud_datasource_list] ([iproduct]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ud_datasource_list_ak4] ON [dbo].[ud_datasource_list] ([laction]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ud_datasource_list] TO [aiadmin]
GRANT INSERT ON  [dbo].[ud_datasource_list] TO [aiadmin]
GRANT DELETE ON  [dbo].[ud_datasource_list] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ud_datasource_list] TO [aiadmin]
GRANT SELECT ON  [dbo].[ud_datasource_list] TO [aipublic]
GRANT INSERT ON  [dbo].[ud_datasource_list] TO [siadmins]
GRANT DELETE ON  [dbo].[ud_datasource_list] TO [siadmins]
GRANT UPDATE ON  [dbo].[ud_datasource_list] TO [siadmins]
GO