Using current_schema allows too much access

I am trying to change our application from a application sercurity model, to indeividual database users using Oracle's security. I can solve the problem of accessing the applications schema by using alter session set current_schema = xxx. One side effect is users could potentially access the application schema using an ad-hoc tool with full rights to modify data.

Does anyone have any ideas how to get around that? Received on Mon Jun 18 2001 - 14:26:33 CDT