用戶是否存在: select * from all_users where username = ‘...’
select * from dba_users where username = ‘...’
主機(jī)名: select host_name from v$instance
客戶機(jī)名: select SYS_CONTEXT('USERENV','HOST')from dual
主機(jī)IP: select utl_inaddr.get_host_address from dual
客戶機(jī)IP: select SYS_CONTEXT('USERENV','IP_ADDRESS') from dual
select * from dba_users where username = ‘...’
主機(jī)名: select host_name from v$instance
客戶機(jī)名: select SYS_CONTEXT('USERENV','HOST')from dual
主機(jī)IP: select utl_inaddr.get_host_address from dual
客戶機(jī)IP: select SYS_CONTEXT('USERENV','IP_ADDRESS') from dual