Re: Quota on TEMP - Identify BO User

Catching up on old Oracle-L:

That is a very interesting work-around.

Where is the use of @variable in a comment documented?

On 9/27/06, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com> wrote:
>
> 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.
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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