Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Hi, we need a query for oem13c repository database so we can generate bi reports
User_4ZMT0
Member Posts: 2 Green Ribbon
Hi,
We are using OEM13c BI publisher reports. We are trying to generate a report for users with dba roles from a target database. What sysman.mgmt$ table or tables do we need to use. I f anyone has any query or repository table names, can you please help
Sincerely
UJ
Answers
-
Hi UJ,
Default users who have the dba role is not collected by OEM, but it can be done. How? See https://oramanageability.wordpress.com/2013/06/20/reporting-users-with-dba-role/
Eric
-
Hi Eric,
Appreciate your suggestion. This has been of significant help.
Following the url, enabled a few target databases, and I see MGMT$DB_ESM_DBAROLE has target database dba role information. I will continue, and will post if there are any more questions.
UJ