TIPS: SQL query to search OAAM 11g User security questions registered in database
Query:
select question from v_user_questions where question_id in (select question_id from v_user_qa where user_id in (select user_id from vcrypt_users where login_id = 'spokuri') and answer != 'null');
-- Siva Pokuri.
select question from v_user_questions where question_id in (select question_id from v_user_qa where user_id in (select user_id from vcrypt_users where login_id = 'spokuri') and answer != 'null');
-- Siva Pokuri.
Nice to find this blog. I would like to appreciate the great work done by You. Thanks you for sharing.
ReplyDeleteIdentity And Access Management