OraFAQ Forum: Reports & Discoverer » Built-in Function sys_context('USERENV','CLIENT

Home » Developer & Programmer » Reports & Discoverer » Built-in Function sys_context('USERENV','CLIENT_IDENTIFIER') Returning ANONYMOUS (Oracle 10.2.0.4.0; Microsoft Windows XP [Version 5.1.2600])

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

Built-in Function sys_context('USERENV','CLIENT_IDENTIFIER') Returning ANONYMOUS [message #456105]

Fri, 14 May 2010 13:28

wtolentino
Messages: 398
Registered: March 2005

Senior Member

our application codes has custom fine grain access control that looks for certain id's such as the userid and machine identifier. some of the codes rely on this sys_context('USERENV','CLIENT_IDENTIFIER') function to compare it's return result to some custom account reference table. one of the server machine that we recently use for testing purpose of new version for Oracle Reports is returning this ANONYMOUS result when the sys_context('USERENV','CLIENT_IDENTIFIER') is queried. this cause issue to our application.

normally, the sys_context('USERENV','CLIENT_IDENTIFIER') returns a null value when it can't recognize of find. how do i resolved it on the server to return the correct result?

our test server machine is running on a Microsoft Windows XP [Version 5.1.2600].

thanks,
warren

Report message to a moderator

Re: Built-in Function sys_context('USERENV','CLIENT_IDENTIFIER') Returning ANONYMOUS [message #456106 is a reply to message #456105]

Fri, 14 May 2010 13:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

How does sys_context('USERENV','CLIENT_IDENTIFIER') differ from

SELECT CLIENT_INFO FROM V$SESSION WHERE SID = <MY_SID>?

Report message to a moderator

Re: Built-in Function sys_context('USERENV','CLIENT_IDENTIFIER') Returning ANONYMOUS [message #456111 is a reply to message #456106]

Fri, 14 May 2010 13:51

wtolentino
Messages: 398
Registered: March 2005

Senior Member

unfortunately we don't have the privilege to select on V$SESSION.

Report message to a moderator

Re: Built-in Function sys_context('USERENV','CLIENT_IDENTIFIER') Returning ANONYMOUS [message #456112 is a reply to message #456106]

Fri, 14 May 2010 13:53

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It differs in the way that it is "SELECT CLIENT_IDENTIFIER FROM V$SESSION WHERE SID = <MY_SID>". Wink

But I recently read a note in Metalink that there is a parameter (which I currently don't remember) that you can set and ensure that both fields have the same value.

@OP
CLIENT_IDENTIFIER is set by the application not by Oracle, so have a look at your application.

Regards
Michel

Report message to a moderator

Re: Built-in Function sys_context('USERENV','CLIENT_IDENTIFIER') Returning ANONYMOUS [message #456113 is a reply to message #456112]

Fri, 14 May 2010 13:57

wtolentino
Messages: 398
Registered: March 2005

Senior Member

thanks michel for your prompt response. how do i check the CLIENT_IDENTIFIER that is set by the application? i'm not sure what to check.

Report message to a moderator

Re: Built-in Function sys_context('USERENV','CLIENT_IDENTIFIER') Returning ANONYMOUS [message #456116 is a reply to message #456113]

Fri, 14 May 2010 14:03

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe
FIND /I "CLIENT_IDENTIFIER" *.*
on all the directories containing your application code?

But maybe there is a default value set by Reports that I don't know as I don't know Reports.
If you want we can move this topic into Reports forum where you should have a better chance to have an answer.

Regards
Michel

[Updated on: Fri, 14 May 2010 14:05]

Report message to a moderator