locked user is still able to login
946773Jun 30 2012 — edited Jul 5 2012Hi everyone!
I create users for my application manually inside the application. I have a process lock_user, which is executed when a button is clicked and it should lock the user provided in the form on the page so he can not login to the application anymore. It seems to work, because in the 'Manage Users and Groups'-section the user is locked. Anyway, the user still CAN login to my application. I'm using the default login page.
Thats the code of my process:
BEGIN
UPDATE user
SET Status_id = '0'
WHERE user_id = :P45_user_ID;
APEX_UTIL.LOCK_ACCOUNT(p_user_name => upper(:P45_USERNAME));
commit;
END;
The update of table user is just for information, i don't use the table for login. What could've went wrong? Any solutions, tips or hints are appreciated!
- friday -
Edited by: 943770 on 30.06.2012 03:01