Re: Reject user connect to database via SQL*PLUS ??

On Mon, 18 Oct 1999 04:09:22 GMT, Agi <agichen_at_my-deja.com> wrote:

>Hello,theres,
> Our users usually use discover to retrive data.
> Can I audit the user who uses sql*plus( or other tools like
> Access,Foxpro--via ODBC) to connect db ??
> Or even reject the requests except Discover users ????
>
> Any Idea ??
> Do appreciate for your help !!
>Rgds,
>Agi
>
>
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Yes you could set the init.ora parameter audit_trail to true and issue an audit connect statement, which would audit all connections. It is not possible to discriminate. Usually questions like this just ask for setting up roles: one role which has very few privileges, but it is the default role. The other role has all privileges associated, but it needs to be enabled by issuing a set role command. In ODBC the set role doesn't work, so those users are effectively shut out. I would expect the avery user is not capable of issuing set role in sql*plus.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Oct 18 1999 - 00:06:59 CDT