Oracle SOA/BPM - Create Application Role from SQL Authenticator in EM Console

This blog is third series of my previous blogs related to SQL Authenticator
SQL Authenticator -1
SQL Authenticator-2
I was facing some issues while creating application role in EM console from DB based Authentication provider.

select soa-infra -> security -> application roles

Click on add button

Choose user as Type and put  some principal name

You will see following error because it would not work for custom authenticators.You have to choose advance option

ERROR

=============

Failed to retrieve users.

Operations error: entity= op=search mesg=Protocol Error LDAP Error 2 : %HOST%:389

Select type as User or Group and enter name of user or group which is present in Database tables

Click OK and put some info in next screen for display and description fields

Click OK and you can seen new application role present in following screen. 

Now you can see these roles in human task activity in JDeveloper