Hi,
I need to implement a configuration to restrict the access to a database.
Currently users connect to a database from their pc using application user.
So I want to eliminate this.
First I want to use invited nodes to register authorized host to connect to the database server, application server, batch server, etc...
Seconds I want to creata a new server and use oracle connection managar and then register it in the listener.
All user that wants to connect to the database using sqlplus or toad must use OCM and their oracle user, for example JWHITE (Jack white), MRED (Micheal Red), etc...
Then a logon trigger blocks all connections with application user coming from OCM.
What do you think about this?