OraFAQ Forum: Reports & Discoverer » Want to show user name in Discoverer report

Home » Developer & Programmer » Reports & Discoverer » Want to show user name in Discoverer report

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

Want to show user name in Discoverer report [message #159750]

Tue, 21 February 2006 03:54

sourajit_seth
Messages: 38
Registered: November 2005
Location: India

Member

In DIscoverer report , I need to show the login and database name , used to connect (and password also if possoble), in any section.

Please suggest , atleast only login name also helps me a lot.

Report message to a moderator

Re: Want to show user name in Discoverer report [message #159799 is a reply to message #159750]

Tue, 21 February 2006 12:36

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Hi,
User login name can be found in the standard Discoverer functions: "user" (create calculation).
Password is never ever shown anywhere Wink

For the databasename, you'll have to create a function in the database, register this in the EUL and allow it to be used in the User edition.
Regards,
Sabine

Report message to a moderator

Re: Want to show user name in Discoverer report [message #159871 is a reply to message #159799]

Wed, 22 February 2006 00:39

sourajit_seth
Messages: 38
Registered: November 2005
Location: India

Member

hi,
that is showing database user.
let say database schema is X.
My login and password to enter discoverer desktop is Y and Z resp.
If I choose "user" function from calculation, it will show "X".
I want to get "Y".

Report message to a moderator

Re: Want to show user name in Discoverer report [message #159992 is a reply to message #159871]

Wed, 22 February 2006 09:38

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Hi,
Do you mean to say that you login to Discoverer with something else than a database-username? That's interesting...
Oh, unless you're working with apps (ebusiness suite) or something like it. Are you?

Regards,
Sabine

Report message to a moderator

Re: Want to show user name in Discoverer report [message #160040 is a reply to message #159992]

Wed, 22 February 2006 22:38

sourajit_seth
Messages: 38
Registered: November 2005
Location: India

Member

Yes sir,
I am using Apps .
Sorry for not to mention earlier.
pls suggest for the same.

Report message to a moderator

Previous Topic:	Having problem w/ Mutiple queries in report
Next Topic:	Discoverer viewer Parameter hiding

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 15:31:41 CDT 2024