Re: Quota on TEMP - Identify BO User

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Wed, 27 Sep 2006 08:31:33 -0700 (PDT)
Message-ID: <20060927153134.79914.qmail@web52812.mail.yahoo.com>

For those of you who are interested, we found a workaround to pass the Login UserId of the business objects user from the application to the database.

The workaround is to include a comment like:

/* User: @variable('BOUSER') */

in the beginning of the SQL statement. This when passed onto the database, expands to expose the Login User Id. So, the sql_text would show, for example, /* User: 'A999' */, if A999 is the application userid of the user that logged into the app.

Deepak

Ruth Gramolini <ruth.gramolini_at_gmail.com> wrote:

> I haven't been following this whole thread, but this
> may help. It is a sql
> script which allows you to see who is logged on with
> a generic application
> login.
>
> set linesize 132
> set pagesize 60
> select substr(client_info,1,33) "Client",
> lpad(sid,3,' ') "SID",
> substr(status,1,1) "S",
> lockwait "Lockwait",
> substr(terminal,1,10) "Terminal",
> substr(to_char(logon_time,'hh24:mi'),1,7)
> "Logon Time",
> substr(username,1,8) "User",
> substr(osuser,1,8) "OSuser",
> substr(program,1,15) "Program"
> from v$session
> where type = 'USER'
> order by 1,2
> /
>
>
> HTH,
> Ruth
>

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 27 2006 - 10:31:33 CDT