Re: verify function restriction

Posted by Claudiu on Mar 29, 2020; 12:14pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/verify-function-restriction-tp8181p8185.html

i am trying below code at new verify function but couldnt setup logic;

    IF     SYS_CONTEXT ('USERENV', 'SESSION_USER') IN ('SYS','CLAUDIU')
       AND
            SYS_CONTEXT ('USERENV', 'IP_ADDRESS') NOT IN ('10.10.10.10'))