title: Restrict Schema Access to Specific IP Address in oracle
body: <p>I want to Restrict Schema Access to Specific IP Address,i tried the below code but still this db is accessible to all the ip's .
  how can i achive this from below code</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER system.check_ip_addresses 
  AFTER LOGON 
  ON DATABASE
  DECLARE 
    l_ip_address VARCHAR2(16) := SYS_CONTEXT('USERENV', 'IP_ADDRESS'); 
  BEGIN 
    IF USER IN ('abc') THEN
      IF l_ip_address IN ('189.14.1.54') THEN
        NULL;
      ELSE
        RAISE_APPLICATION_ERROR(-20000, 'Can not log in from this IP address (' || l_ip_address || ')');
      END IF;
    END IF;
  END; 
  /
  </code></pre>