Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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