system用户创建触发器,登录后触发检查 CREATE OR REPLACE TRIGGER system.check_ip_addresses_test AFTER logon ON DATABASE BEGIN IF USER IN ('ZKBMANUAL' ) THEN IF sys_context('USERENV', 'IP_ADDRESS') NOT IN ( '10.192.15.35', '10.192.15.101') THEN raise_application_error
在/etc/profile里面加入以下代码 PS1="`whoami`@`hostname`:"'[$PWD]' history USER_IP=`>/dev/null| awk '{print $NF}'|sed -e 's/[()]//g'` if [ "$USER_IP" = "" ] then USER_IP=`hostname` fi if [ ! -d /tmp/login_data ] then mkdir /tmp/logi