Hi there,
I would like to use MS Query in XL to enquire our Informix database. In my view the tool is easy to use, has SQL wizards to assist users join tables and retrieve data. The only problem I have is that it also opens the database to potential unaudited SQL updates and/or deletes.
1. Wondering if someone knows if it is possible to restrict MS Query to only allow SELECT statements rather than all SQL commands.
2. Our users have been using Crystal Query which is an easy to use tool but is no longer supported by Business Objects.
Info on XL Query security and/or user friendly query tools preferably with wizards will be very much appreciated.
Thank you,
Luis
I would like to use MS Query in XL to enquire our Informix database. In my view the tool is easy to use, has SQL wizards to assist users join tables and retrieve data. The only problem I have is that it also opens the database to potential unaudited SQL updates and/or deletes.
1. Wondering if someone knows if it is possible to restrict MS Query to only allow SELECT statements rather than all SQL commands.
2. Our users have been using Crystal Query which is an easy to use tool but is no longer supported by Business Objects.
Info on XL Query security and/or user friendly query tools preferably with wizards will be very much appreciated.
Thank you,
Luis
