 Restrict the system connecting to the database [message #301841] |
Fri, 22 February 2008 00:03  |
dhanumolu
Messages: 7
Registered: January 2008
|
Junior Member |
|
|
Hi all,
We are using Oracle9i database with 7 instances running on the same server. One of the instance is been used by 15 members with same user to connect to the database.
As there is limitation that only 3 members should connect to that instance. While other users should connect to other instances.
Is there any way to restrict the system IP for that particular instace. I appreciate any help from u.
Thanks in Advance.
Dilip
|
|
|
|
|
|
|
|
| Re: Restrict the system connecting to the database [message #301875 is a reply to message #301874] |
Fri, 22 February 2008 02:14  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
SYS_CONTEXT function gives you the IP (just have a look at the link I gave).
In addition to the link previous link on CREATE TRIGGER, read Application Developer's Guide - Fundamentals, Chapter 9 Coding Triggers, there are examples of trigger.
More I'm just seeing that in LOGON trigger you can use a variable named ora_client_ip_address that directly gives you the IP. Good chapter to (re)read!
Regards
Michel
[Updated on: Fri, 22 February 2008 02:14] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
