Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Weblogic User details from Metadata DB
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.
Answers
-
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#BIESG317look at section 16.9
0 -
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
0
