OraFAQ Forum: SQL & PL/SQL » Retriving OS User Name using Job ID

Home » SQL & PL/SQL » SQL & PL/SQL » Retriving OS User Name using Job ID

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Retriving OS User Name using Job ID [message #260651]

Mon, 20 August 2007 11:01

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

Is that possible to retrive Os User Name using Job id and using which table/view?

Cheers
Sanka

Report message to a moderator

Re: Retriving OS User Name using Job ID [message #260677 is a reply to message #260651]

Mon, 20 August 2007 12:30

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

You could user USERENV('TERMINAL') and then use this value against TERMINAL in V$SESSION.

Report message to a moderator

Re: Retriving OS User Name using Job ID [message #260684 is a reply to message #260651]

Mon, 20 August 2007 12:52

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select sys_context('userenv','os_user') from dual;
SYS_CONTEXT('USERENV','OS_USER')
-----------------------------------------------------------
Michel

1 row selected.

SQL> select osuser from v$session where sid=sys_context('userenv','sid');
OSUSER
------------------------------
Michel

1 row selected.

Regards
Michel

Report message to a moderator

Re: Retriving OS User Name using Job ID [message #260899 is a reply to message #260684]

Tue, 21 August 2007 04:14

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

I need to show which OS User run the job.
That means I have to mapped the dba_jobs with such a table/view so that I can see the OS User Name for that perticular job_id.

Regards
Sanka

Report message to a moderator

Re: Retriving OS User Name using Job ID [message #260903 is a reply to message #260899]

Tue, 21 August 2007 04:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The OS user that executes a job is the OS user that starts the instance.

Regards
Michel

Report message to a moderator

Re: Retriving OS User Name using Job ID [message #260910 is a reply to message #260903]

Tue, 21 August 2007 04:30

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

No this user is a client machine user.

Regards
Sanka

Report message to a moderator

Re: Retriving OS User Name using Job ID [message #260912 is a reply to message #260910]

Tue, 21 August 2007 04:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, the OS user that executes the job in dba_jobs is the OS user that started the instance.
This is not a question, this is an assertion.

Regards
Michel

Report message to a moderator

Re: Retriving OS User Name using Job ID [message #260915 is a reply to message #260912]

Tue, 21 August 2007 04:44

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

Ok. I've got it.
Thanks Michel.

Cheers
Sanka

Report message to a moderator

Previous Topic:	what tools can write select statement better?
Next Topic:	create trigger on Sequence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 19:09:44 CST 2024