Windows Server 2003 – Are ODBC Data Sources set per-user

You want to look at the question a different way: what you want to do is capture the query that BusinessObjects is executing on the database server, and then run that same query yourself on the database server.

For example, if it's accessing data stored in Microsoft SQL Server, you can ask the database administrator to run Profiler to capture your queries while you're executing the report in BO. He can then give you the queries you ran, and you can execute those same queries in your own tools to get the results directly.

Update: I saw your edits, and what you're asking for just isn't possible. BOXI isn't a middleware tier for accessing millions of rows of data via ODBC. You either need to get the admins to allow you to export more data, or you need to connect to the underlying database.

Remove the user from the db_datareader role and just give it SELECT rights against the views you created for it. You don't mention which version of SQL Server, but the start point is invariably opening the user's properties screen and looking for something that says Permissions.