Allow Ad Hoc Distribution Queries for all users

Question

Hi,

I am using AD Hoc Distribution Queries to transfer Data from MS SQLServer 2008 to MS Access. The process is started using a single SQL Statement:

INSERT INTO OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\temp\target.mdb;User ID=Admin;Password=;')...testtable select * from dbo.testtable  

To do that I have set the Ad Hoc Distribution Query parameter to 1 via

sp_configure 'Ad Hoc Distributed Queries', 1

Everything works fine as long as the statement is executed with a sysadmin database-permission.

When I try to execute the statement as a normal db-user, the statement fails with a permission denied error message.

How can I grant all users to execute ad hoc distribution statements?

Thanks in advance

Marcus