Re: Quota on TEMP - Identify BO User
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: ruth.gramolini@xxxxxxxxx, john.kanagaraj@xxxxxxxxx
- Date: Wed, 27 Sep 2006 08:31:33 -0700 (PDT)
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
