Reporting on used system privileges

In this recipe, you'll view collected data about the usage of system privileges during a capture interval.

Getting ready

You'll need an existing user who can create a privilege analysis policy (has the CAPTURE_ADMIN role and the SELECT ANY DICTIONARY privilege), for example, the SYSTEM user.

How to do it...

1. Connect to the database as system or a user who has appropriate privileges:

   $ sqlplus system
   

2. View system privileges that the user ALAN used:

   

   Figure 37 - The used system privileges

3. View grant path for the used system privileges generated by ALL_PRIV_POL for the user ALAN:

   

   Figure 38 - The Grant path

There's more...

In EM 12c, after you have generated the report, select the policy and from Actions drop-down menu, select Reports. The Usage Summary report will open (see Figure 39).

Figure 39 - Usage Summary

Click on the tab Used and choose All for Match radio button, Policy: ALL_PRIV_POL, User Name: ALAN, and click on the Search button. Results are shown in Figure...