Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restrict Oracle User ID's From Accessing Database Through Certain Apps

728965Apr 16 2010 — edited Apr 19 2010
Hi

Is there any way of restricting usre ID's from accessing an Oracle database through certian applications while allowing the same user ID access to the database through other applications?

The problem is that I have an application which uses functional ID 'lmtdev' to access the database. If possible I would like to restrict this functional ID from accessing the database through applications such as SQLTools and TOAD so support users(who know the password) can not access the database through this user ID.

I hope that has been explained clearly. If not please ask and I'll try to clarify.

Cheers
Paul
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2010
Added on Apr 16 2010
6 comments
1,944 views