SQL user role

A database role? Ok.
Open Enterprise Manager, and expand the database you want this role in.
right-click on Roles and choose New Database Role.
Give it a name, then click Add and add any Users you want to be members of the role. Click OK to close.
Now, right-click on the new role -> Properties. Click the Permissions button.
A window comes up with every table, view and stored procedure in that database. To the right of each item is 6 columns, SELECT, INSERT, UPDATE, DELETE, EXEC, DRI.
Now,to be able to export data, you would need to be able to SELECT the data. So, for each table/view/stored procedure in your database that you want his role to have access to, click the checkbox (making a green check appear).
When you are done, clickOK.

That is it. Now, members of that role can do a select, which should let them export the data. They cannot add data, change data, delete data, or run an application. They can do queries against the data.

hope this helps