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: https://blogs.oracle.com/pa/resource/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
...


Comments:

Post a Comment:
  • HTML Syntax: NOT allowed