Re: Acessing data - security versus ease of use

Snid wrote:

> I was wondering how people allow clients to access the data from their
> databases?
>
> All of our machines are locked down with firewall rules, so that only a few
> people are allowed through the firewall; however, this prevents people
> accessing the data with ODBC which means complex methods of replicating data
> and allowing it to be accessed are used, ie dumping the data into another
> database which is less secure.
>
> What sort of middle tier applications or gateways are people using?
>
> Are there any alternatives such as using some sort of ODBC connection over
> https?
>
>

It would be remarkably valuable to know a few things first:

1. Verion and edition of Oracle.
2. Hardware platform and operating system.
3. What front-end tools are being used.

But in general ... I never ... and I mean NEVER ... use ODBC to connect to a database. There are plenty of solutions. Knowing more about what you are doing would be a first step to making a recommendation.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)