I have a very large Oracle DB. I have a group that requires many custom queries that I do not want them poking around the DB at all and do not want to put out the money for 20 showCase licenses or any think like it. All users require (and have) Oracle client and they can use Plus80 to hit queries (using scripts similiar to below). I have created the queries and they all open on the users PC that runs them. This is how the scripts are created.
1. Create the SQL
SELECT
FROM
HAVING
GROUP BY
HEADER HEADER……………….etc
This genereated a report to local ‘C’ and opens it in notepad.
2. Now there is a *.BAT file with the following command:
plus80 user/password@TEST @script.sql
Trying to make things more secure, how can I “compile” these two files together so the user cannot see the ‘guts’ (username password, connect string, etc)? I have VB6.0 Enterprise Edition but I’m not familiar with it, points offered are for hints that lead to the answer, definate resolution will double points. Additional ideas can be sent to BOTH eparisek@mtga.com and xmenx10@hotmail.com
Thank you,
Eric