Few questions recently on finding out who is logged into BIP so you can secure a dataset based on the user. In 5.6.2 the support was there, well sort of ... its a nasty work around but can be done. Check out the forum threads for the solution.
Im pleased to say in 10.1.3.2 it's sooo much better.
You can add the following string to your data sets, ':xdo_user_name' to limit the returned data set.
For example:
select EMPLOYEES.LAST_NAME as LAST_NAME,Notice the use of the lower() function , the xdo_user_name will always be in lowercase format.
EMPLOYEES.PHONE_NUMBER as PHONE_NUMBER,
EMPLOYEES.HIRE_DATE as HIRE_DATE,
:xdo_user_name as USERID
from HR.EMPLOYEES EMPLOYEES
where lower(EMPLOYEES.LAST_NAME) = :xdo_user_name
Do you know where can i found the list of the build-in (system) paramters/variables like :xdo_user_name.
regards,
mustafa
Do I need to configure something?