Re: Restricting ODBC access to Oracle

In article <93fjfa$178$1_at_nnrp1.deja.com>,   bhogak <bhogak_at_my-deja.com> wrote:
> I wish to restrict end-users from accessing our Prod database using
> ODBC (MS-Access) or SQL*Plus. In the later case, I think I can use the
> Profile tables to control their access. But how can I control their
> access thru ODBC?
>
> Thx.
> Bhogak.
>
> Sent via Deja.com
> http://www.deja.com/
>

I am assuming that you only want these people to access the system via a specific app. The common approach here is to grant all access to roles. These roles are not default and are password protected. The application enables the role(s) when the user signs in and all is ok.

--
Doug Coan
Oracle Certified Professional DBA


Sent via Deja.com
http://www.deja.com/