Installed oracle client in /app/obiee .. So should i change it to /app/Oracle/Middleware/Oracle_Home? Also Java installed in the path abovce.. So which path i should use for java?

Hello Gianni, Thanks alot for your reply. But if i remove it from the members of the group, Will i get login to BI?

Dear Robert, Actually I need Sales user under sales application role only, not under cost appication role

Hello, This is how it is displayed

Couldnt complete the data adapter configuration. IT was throwing an error and we couldnt fix it yet. configuring sql authenticator in weblogic

While configuring database adapter we need to execute the below script ./libovdadapterconfig.sh -adapterName userGroupAdapter1 -adapterTemplate adapter_template_usergroup1.xml -host 10.0.0.227 -port 9704 -userName weblogic -domainPath /app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi2/ -dataStore DB -root…

Let me try it and will update you..

Do we need to configure data adapter other than the data source in weblogic? any config file ?

Yes.. I did.. and those users and groups listed in EM.. Now i am trying to add it to the application roles.. but it is not displayed while adding to application roles.

Those groups and users are not listed when i try to search for adding to application roles ..

No.. .. I didnt know about it.. Let me add and check.

Earlier i created some dummy tables and inserted some users to it and tried to modify the SQL Authenticator query for those tables. Now i have created the exact same tables mentioned in the tutorial and it listed the users and groups in weblogic. Now How to add those groups to the existing application roles. When i tried…

Yes Configured Data source for oracle and it successfully connected.

I am able to find the users and groups in weblogic now? Should i map the application roles from Fusion Middleware?

I have used the same steps as below.. http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/wls/12c/12_2_1/sqlauthenticator/sqlauthenticator.html

Available from next version it seems... Is it possible to add the functionality with some patches?

Already done ......

It worked like a charm

Thank you very much.. I got a link by googling.. Let me check that ... SIMPLETHORA: Error in OBIS1 after restart and repository is empty

Also if i have a backup RPD of few weeks ago, how can i upload it? Uploadrpd also not working