Weblogic User details from Metadata DB

User_S35K3 · Nov 13, 2019 12:25AM

Hi,

I am working on OBIEE 12.2.1.3.0. I have a simple question that I need to know weblogic users details like which user are created in this month or any specific period of time, user is member of which group, on which report or dashboard it has access. I have also enabled usage tracking but this does not show which user was created at what time or on which reports it has access and what type of access.

I need all this information from metadata DB table name.

Joel Acha · Nov 13, 2019 12:42AM

You can’t get all of this information from a single source. Regarding the User creation dates, you might be able to get this from the WebLogic export facility - https://www.oracle.com/webfolder/community/middleware/3687605.html

With regards to the user groups, you’ll need a WLST script and there are loads of examples online. Here’s one that @Michael Verzijl put together sometime ago - https://mverzijl.wordpress.com/2012/08/23/weblogic-wlst-get-users-and-groups/amp/

Finally, to get the User dashboard privileges, you’ll need to get this out of a catalog manager report - https://docs.oracle.com/middleware/1221/biee/BIESG/prescatadmin.htm#BIESG317

look at section 16.9

Gianni Ceresa · Nov 13, 2019 2:43AM

As Joel said there isn't a single source for that, the database can only give you the users / groups / role part if you ask nicely. Everything else (Catalog permissions) must be asked to OBIEE directly.

As alternative to WLST you can also query the OPSS schema tables. It's less documented and require some "creativity" but can still be done...

https://speakerdeck.com/gianniceresa/gdpr-and-you-the-nightmare-of-ba?slide=23

Oracle Analytics Forum

Categories

Weblogic User details from Metadata DB

Answers