Re: Restricting ODBC access to Oracle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 9 Jan 2001 20:07:14 +0100
Message-ID: <93fo35$9qktn$3@ID-62141.news.dfncis.de>

create a role with select privileges only. Make this role the default role. Other roles need to be enabled by issuing the set role command. This will not work from Access as the command is executed in a separate Oracle session.

Hth,

Sybrand Bakker, Oracle DBA

"bhogak" <bhogak_at_my-deja.com> wrote in message news:93fjfa$178$1_at_nnrp1.deja.com...
> 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/
Received on Tue Jan 09 2001 - 13:07:14 CST