CREATE TABLE [dbo].[SimpleRequest]
(
[RequestId] [int] NOT NULL,
[SourceProviderId] [int] 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] [binary] (32) NULL,
[SourceOther] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestProviderId] [int] 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] [binary] (32) NULL,
[DestOther] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestTableName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestTableOverwrite] [tinyint] NOT NULL,
[BulkTransfer] [tinyint] 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