Restrict login for a particular user to be only from particular m achines

All,
 
A client wants to be able to limit login for particular database user to be 
from a specified set of client machines.  My understanding of login restriction 
at the listener level is that it is possible only to limit all database logins 
based on machine.  I've been experimenting with login triggers that inspect 
sys_context('userenv','host'), but haven't figured out how to prevent the 
session from proceeding if the client machine name is not in the approved list. 
 If anyone has any ideas or suggestions I'd be most grateful.
 
Thanks,
 
Paul Baumgartel 
CREDIT SUISSE 
Information Technology 
DBA & Admin - NY, KIGA 1 
11 Madison Avenue 
New York, NY 10010 
USA 
Phone 212.538.1143 
paul.baumgartel@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 

 


==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

Other related posts: