Current session user

Hi Dusan,

The api_security API does not provide such a function but you can use api_session.add API to add the current user to the session as a session parameter once the login is successful. Then in your code, you can retrieve the current user using the api_session.getValueTx API whenever you need.

Kind Regarda,
Yalim

Hi Yalim,

I want to audit table changes using current user id. Tables are in the "APP_DB" oracle schema, FS PL/SQL code are in the "APP_UI" schema. After log in I keep current user id with api_session.add() (schema APP_UI). I've created after-update trigger on the table and try to get session value with api_session.getValueNr() (schema APP_DB). But I get a null value of a current user (do an update action via FS-form).

Can I get a session value in this case?

Best regards, Andrew

Hi Andrew,

I haven't tried this myself but I cannot think of a reason why this wouldn't work. I can think of two issues though: 1. The parameter you are getting might not be of type Number. 2. You might have more than one Formspider installation in your database and, APP_UI and APP_DB schemas are pointing to different ones.

Hope this helps.

Kind Regards,
Yalim