Re: Quota on TEMP - Identify BO User

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 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: