OIM: User unlock query

The following query can be executed to unlock an OIM user:

UPDATE USR SET USR_LOCKED=0,USR_LOGIN_ATTEMPTS_CTR=0, USR_LOCKED_ON = null,USR_MANUALLY_LOCKED = null  WHERE USR_LOGIN='<PROVIDE_USER_LOGIN>';

OIM Query: List of roles without access policy attached

SELECT
  ugp1.ugp_name AS "Role Name",
  ugp1.UGP_DISPLAY_NAME AS "Role Display Name",
  ugp1.UGP_DESCRIPTION AS "Description",
  ugp1.UGP_CREATE AS "Create Date"
FROM ugp ugp1
WHERE ugp1.ugp_name not in (select  ugp.ugp_name
from pol
left join pog on pog.pol_key=pol.pol_key
join ugp on ugp.ugp_key = pog.ugp_key)
;