Oracle Portal - identifying who has signed on
From: SDG <simong_at_explor.co.uk>
Date: Mon, 12 Feb 2001 13:48:45 -0000
Message-ID: <hNRh6.121$yi4.131253_at_newsr1.u-net.net>
Date: Mon, 12 Feb 2001 13:48:45 -0000
Message-ID: <hNRh6.121$yi4.131253_at_newsr1.u-net.net>
[Quoted] I am wanting to write a sql statement for a portal report that only returns
rows for the user who has logged on.
[Quoted] Is there a procedure or api to do this.
Basically I am wanting to do what SYS_CONTEXT ('userenv','session_user') does in sqlplus for the database user.
eg.
select *
from my_table
where user_name = (portal sign on name)
Thanks in anticipation. Received on Mon Feb 12 2001 - 14:48:45 CET