Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: ? Challenging Question: Current CE User Name ? Post Reply Post New Topic
Author Message
peter
Groupie
Groupie


Joined: 08 Apr 2007
Location: United States
Online Status: Offline
Posts: 51
Quote peter Replybullet Topic: ? Challenging Question: Current CE User Name ?
    Posted: 17 May 2007 at 12:20pm
Hi Brian or some expert !!!
This is challenging question but would be a big benefit solution to the CR/CE world!!!

Here is the question that we've been trying to find a solution:

Let's go through this scenario:

1) A user log onto the CE server and typed in his Id/pw.

2) He/She is now on the server. He/She has not click to run any report yet. His/Her logging-Id must have been stored some where in the server (e.g. session header, cookies, system variable etc)

3) The user now runs a reports. His/Her logging- Id is now passed onto the "Current CE UserName"

What we really need is to have the logging-Id avaible inside the DB2 stored procedure---such as those DB2 variables: CURRENT_DATE, USER, SESSION_ID etc.)-- so that we can use it to filter the data. Can we stamp some system variable that currently not in use or create some new variable and store that info ? Or may be it's alreay avaible in some variable within DB2.

IP IP Logged
WLWes
Newbie
Newbie


Joined: 12 Jan 2007
Online Status: Offline
Posts: 6
Quote WLWes Replybullet Posted: 28 May 2007 at 10:40pm
I haven't set this up myself yet but this might be what you are looking for - in the authentication section of CMC there is a checkbox under the heading:  "Propagate Logon to Data Source Credentials" I think that this will enable BOE to use the "DB_USER" variable to run queries or SPs against the datasource. You should be able to find instructions on it's use in the administrator's guide
IP IP Logged
peter
Groupie
Groupie


Joined: 08 Apr 2007
Location: United States
Online Status: Offline
Posts: 51
Quote peter Replybullet Posted: 29 May 2007 at 8:47am
Hi WLWes:
Would you try it ? I talked to my CE Administrators but they dont think that would work.
IP IP Logged
WLWes
Newbie
Newbie


Joined: 12 Jan 2007
Online Status: Offline
Posts: 6
Quote WLWes Replybullet Posted: 29 May 2007 at 10:27pm
what version of enterprise are you using?
IP IP Logged
peter
Groupie
Groupie


Joined: 08 Apr 2007
Location: United States
Online Status: Offline
Posts: 51
Quote peter Replybullet Posted: 30 May 2007 at 8:46am
Version 10 both CR and CE.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.