Re: Oracle Security

>>We want to ensure that our users access a database thru a particular
 application,
>>and not thru SQL*PLUS, or some other Oracle or 3rd party reporting tool or
>>database residing on another host. Users will be restricted from the UNIX
>>command line, and thus won't be able to execute commands.
>>
>>I understand that the PRODUCT_USER_PROFILE table will allow you to 'disable'
>>what user's can do within SQL*PLUS, but can other tools be specified? And
>>moreover, is there a way of restricting access from other programs/DBs/tools?
>>Does SQL*NET have such a capability to filter out users NOT coming in thru
>>this application?
>>
>>Any answers and/or comments are appreciated!
>>
>>Thanks,

We use a password encryption scheme that must be set by the DBA and imbeded in every approved application.

We use this in C++ applications as well as Oracle Forms.

This requires some work to setup, but it is the only way to accomplish what you want.

If you need more help in this please email me and we can arrange something for you.

Thanks.

Ralph Received on Thu Jul 20 1995 - 00:00:00 CEST