Schema wise client access control
I am using Oracle Standard edition 10g on RHEL. One single instance of DB server runs and various clients connect to it using JDBC, SQL Plus, Oracle Forms etc. The database has many user schemas like canteen, stores, accounts etc having various tables and other objects.
In what way can I configure this system such that I am able to restrict the client access for individual schema. For e.g I wish that the canteen schema should be accessible only from specific client IPs. Currently the firewall on the server itself takes care of this but this makes it common for all schemas. Hence, it cannot be an OS level setup.
In what way can I configure this system such that I am able to restrict the client access for individual schema. For e.g I wish that the canteen schema should be accessible only from specific client IPs. Currently the firewall on the server itself takes care of this but this makes it common for all schemas. Hence, it cannot be an OS level setup.
0