CREATE TABLE [dbo].[SimpleRequest]
(
[RequestId] [dbo].[IDENTIFIER_TYPE] NOT NULL,
[SourceProviderId] [dbo].[IDENTIFIER_TYPE] NOT NULL,
[SourceServerName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SourceDatabaseName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SourceLoginName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SourceLoginPassword] [dbo].[DES_PASSWORD_TYPE] NULL,
[SourceOther] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestProviderId] [dbo].[IDENTIFIER_TYPE] NOT NULL,
[DestServerName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestDatabaseName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestLoginName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestLoginPassword] [dbo].[DES_PASSWORD_TYPE] NULL,
[DestOther] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestTableName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestTableOverwrite] [dbo].[BOOLEAN_FLAG] NOT NULL,
[BulkTransfer] [dbo].[BOOLEAN_FLAG] NULL,
[DeleteString] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SimpleRequest] ADD CONSTRAINT [pk_SimpleRequest] PRIMARY KEY CLUSTERED ([RequestId]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[SimpleRequest] TO [InfoPumpAdmin]
GRANT INSERT ON  [dbo].[SimpleRequest] TO [InfoPumpAdmin]
GRANT DELETE ON  [dbo].[SimpleRequest] TO [InfoPumpAdmin]
GRANT UPDATE ON  [dbo].[SimpleRequest] TO [InfoPumpAdmin]
GRANT SELECT ON  [dbo].[SimpleRequest] TO [InfoPumpUsers]
GRANT INSERT ON  [dbo].[SimpleRequest] TO [InfoPumpUsers]
GRANT DELETE ON  [dbo].[SimpleRequest] TO [InfoPumpUsers]
GRANT UPDATE ON  [dbo].[SimpleRequest] TO [InfoPumpUsers]
GO