Hey there.
The way I do this at work is by giving the client an Access database, where using ODBC, I link it to the Oracle/MSSQL database tables.
This way, they can use Microsoft Access to create their own ad-hoc queries / reports etc...
MS Access is a very powerful and affordable ad-hoc query tool to interface most databases supported by ODBC.
If you are concerned with security, you can implement MDW security and password protection against the MS Access database.
Your client will be extremely happy with such a solution... He can't complain about this, as you are giving him full access to the tables...
You may have to add some security restrictions to to only allow viewing permissions.
Regards from Down Under.
Slashdot Mirror
Hey there. The way I do this at work is by giving the client an Access database, where using ODBC, I link it to the Oracle/MSSQL database tables. This way, they can use Microsoft Access to create their own ad-hoc queries / reports etc... MS Access is a very powerful and affordable ad-hoc query tool to interface most databases supported by ODBC. If you are concerned with security, you can implement MDW security and password protection against the MS Access database. Your client will be extremely happy with such a solution... He can't complain about this, as you are giving him full access to the tables... You may have to add some security restrictions to to only allow viewing permissions. Regards from Down Under.