X

Oracle Customer Engineering & Advocacy Lab (CEAL) Blog covers Oracle Analytics Cloud, Oracle Analytics Server and...

BI Web service security client - authentication operations for 11.1.1.6 and 11.1.1.7.x

This wlst/python script connects to bi security web service to authenticate a user specified in the "ObieeWebServiceClient.properties" file. In 11.1.1.7, this calls: getAuthenticatedUserWithLanguageAndProperties operation of the /bisecurity/service web service.

In 11.1.1.6, this calls authenticate operation of the /bimiddleware/security/service web service.

This returns as part of the xml response the user unique identifier (guid) and other permissions/roles for the user. This is useful when debugging an issue with OBIEE security.

The script has to be run with %ORACLE_HOME%\oracle_common\common\bin\wlst.cmd (sh)

Script is available there: //cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/f4a5b21d-66fa-4885-92bf-c4e81c06d916/File/0dc22ee1558e9aeb90fa86a0f52d84fa/obieewebservicesecurityclient.zip

 Example:

SET ORACLE_HOME="C:\Oracle\Middleware\Oracle_Home"

call %ORACLE_HOME%\oracle_common\common\bin\wlst.cmd
ObieeWebServiceClient.py > ObieeWebServiceClient.log


Results: with 11.1.1.7.1:


** getting obiee version **

Connecting to t3://server.mycompany.com:7001 with userid weblogic ...

OBIEE version:11.1.1.7.0


** getting system.user **

System user used for connection to bi web service:BISystemUser


** Calling bi web service for authentication **

Calling url:http://server.mycompany.com:9704/bisecurity/service with
user:test

...

<result><GUID><value>8418E120AF5911E38F3585A97A3473DB</value></GUID><name>test</name><description></description><displayName>test</displayName><properties><name></name></properties><language>en</language><timezone></timezone><tenantGUID
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:nil="true"/><roles><GUID><value>AuthenticatedUser</value></GUID><name>AuthenticatedUser</name><description></description><displayName>Authenticated
User</displayName></roles><roles><GUID><value>BIConsumer</value></GUID><name>BIConsumer</name><description></description><displayName></displayName></roles><permissions><resourceName>AtAGlance</resourceName><resourceType>rtd_dc_persp</resourceType><actions>dc_perspective</actions></permissions><permissions><resourceName>/</resourceName><resourceType>oracle.fr</resou

...


Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.