Re: How to Restrict DB access based on Client Type or Adress.

Transparente_at_mail.telepac.pt (Miguel Nogueira) writes:

>
> How can this be done using sql*net?
> The implemented option is based on 'set role x identified by y' on a
> session basis.
> This way everyone can actually connect to DB.
> I can observe that V$SESSION gives me many type of info that I would to
> use in order to restrict access. For example I would like to restrict
> ODBC or other type of connections.
> Basically I would like to give access only to people:
> -Using Forms (or other tool that I would be able to describe somewhere )
> -No SQL*PLUS.
> -Network Identified connections (IP).
> (Like Internet authentication to a proxy).
Unfortunately, there is no way to do what you want. Oracle has no way of restricting access by application type.

--

                                        Rick
                                        Rick Wessman
                                        Distributed Data Security
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com