Post Authentication Process to set Application Item based on query
566825Mar 13 2007 — edited Mar 15 2007I have LDAP Authentication working... and it sets the APP_USER.
Upon successful authentication, I'd now like to query a table and assign an application item of APP_USER_ID so that I can authorize based on this value throughout the application.
I have the application item created. Reading in this forum, I've put the following within the Post-Authentication Processing...
begin
for c1 in (select STAFF_ID_FIELD from STAFF_TABLE where LOGIN_NAME = v(':APP_USER')) loop
:APP_USER_ID := c1.STAFF_ID_FIELD;
exit;
end loop;
end
Am I approaching this correctly? Any ideas how to get this to work?
Matt
(name added - Thanks Scott)
Message was edited by:
nbsp