DevOps, CI/CD and Automation

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!

How do I prevent misuse of ODBC access to oracle

430090Nov 17 2004 — edited Nov 19 2004

Greetings,

We have a application based on Oracle Forms 6i and a Oracle 8.1.7 database. Within the forms appplication I can restricted what the users can do.
However I want them to run queries I made in Microsoft Access. So I made a Oracle account with only select rights on the tables and views. The access application the users use only uses this account to access the Oracle database. But the users have their normal Oracle account which they use with the Oracle Forms application. This normal user account have update and delete rights on the Oralce tables. The users need these rights when using the Oracle Forms application.
The probleem is that since I installed the Oralce client and ODBC drivers on the uswer PC's, users have the means to login via ODBC with their normal Oracle account. Then they can then delete records and mess up the database.
Any ideas how I can prevent this?

Thanks in advance,
Phil Leslie

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2004

Added on Nov 17 2004

#odbc, #windows-and-net

4 comments

949 views