Thursday, October 22, 2015

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.

1 comment:

  1. Nice to find this blog. I would like to appreciate the great work done by You. Thanks you for sharing.

    Identity And Access Management

    ReplyDelete