Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: why 'DBSNMP'and 'SYSMAN' are found when I tried to get the valeu of sys_context('userenv','session_user')?

RE: why 'DBSNMP'and 'SYSMAN' are found when I tried to get the valeu of sys_context('userenv','session_user')?

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Wed, 5 Apr 2006 14:39:07 -0400
Message-ID: <51327ABA927BEF4B96590554CEA7832C01930B82@enhbgpri05.backup>


DBSNMP is your oracle agent and I would guess you are running jobs from oms using SYSMAN to connect. That being the case your capture is normal.    

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of xiaoyezi.xyz_at_163.com
	Sent: Wednesday, April 05, 2006 11:36 AM
	To: Oracle-L_at_FreeLists.org
	Subject: why 'DBSNMP'and 'SYSMAN' are found when I tried to get the valeu of sys_context('userenv','session_user')?
	
	
	I want to find the value of the 'sys_context('userenv','session_user')'when the user longon of database,and I wrote the folloing statements:

	 

	create user t identified by t;

	grant connect,resource to t;

	 

	create user t1 identified by t1;

	grant connect,resource to t1;

	 

	 

	conn t/t;

	create table u (username varchar2(20));

	grant select,delete on u to t1;

	 

	conn system/manager as sysdba;

	 

	create or replace trigger user_logon

	after logon

	on database

	begin

	insert into t.u values(sys_context('userenv','session_user'));

	end;

	/

	 

	and then:

	 

	SQL>conn t1/t1;

	SQL> select * from t.u;

	 

	USERNAME


--------------------
T1 SQL>conn t/t; SQL> select * from t.u; USERNAME
--------------------
T1 T SQL> grant insert on u to t1; SQL> select * from t.u; USERNAME
--------------------
T1 T SYSMAN now 'SYSMAN' is found, why? and sometimes, it is 'DBSNMP', is there some kind of regulation about the emergence of 'SYSMAN'and 'DBSNMP'?anybody can tell me? Thank in advance.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 05 2006 - 13:39:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US