Page 1 of 1
Database Access Authorization
Posted: Fri Apr 21, 2006 2:51 am
by 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
Posted: Fri Apr 21, 2006 3:47 am
by 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?
Posted: Tue Apr 25, 2006 2:08 am
by 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