EM12c: How to View All of the Credentials Exist for All Users

In another question on OTN forum, someone says that there are multiple (EM12c) users and they can create their own credentials. They ask how to view all of the credentials that exist for all users. A valid answer is already given: An EM administrator, including sysman, cannot view the named credentials owned by other administrators unless an explicit grant is provided.

namecred1

I logged in as SYSMAN to Enterprise Manager Cloud Control console and checked the named credentials. As you can see, even SYSMAN can only see own credentials. So isnt’t there any way to override this “reasonable limitation”? I say “it’s reasonable”, because in my opinion, even SYSMAN (the Repository Owner) shouldn’t need to see the credentials of others. Anyway my curiosity wins, so I connected to repository Database (using Oracle SQL Developer) and examined tables, and I write the following query to show all named credentials:

To be able to filter out credentials which are internally created by Enterprise Manager, I added a “where condition” to the query. Here’s the result:

namecred2

So now you may wonder if it’s possible to get the passwords of these credentials? I’ll write about it on tomorrow 🙂

Please share
  •  
  •  
  •  
  •  
  •  
  •  

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

Leave Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.