Database Access Authorization

[omerjaved100]

Any one knows the solution to build a protection layer on database that only Specified IP Addresses can connect to the database?

Environment:
9i database (Protection to be applied)
Clients: 8i or 9i


Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693

[admin]

Here is a very userful link explaining database control methods,

http://www.lc.leidenuniv.nl/awcourse/or ... s.htm#3114

For ERP you should read metalink notes,
Best Practices for Securing Oracle E-Business Suite (Note 189367.1)
E-Business Suite Recommended Set Up for Client/Server Products (Note 277535.1)

Secondly your application(s) may be using same database user name so how you are interested to restrict the user from one IP?

[omerjaved100]

Problem is not being resolved as i give u its details..........

Let i have some IP Addresses like 192.168.8.252 and 192.168.4.65. I want that only these IP Address can connect to the database directly via Sql/PLSql?

Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693