I often encounter Oracle DBAs with "strong opinions" on how ZENworks should use their RDBMS. Recently I've been working with one group who revoke what they feel to be unnecessary permissions as soon as an upgrade is complete and re-grant them for the next upgrade pass. There is evidence that some other permissions have been altered over time - just can't tell how much drift there has been.

It would be helpful to have a script that could be run to audit the permissions enabled on an Oracle ZENworks database (ZENworks and Audit schemas). The output would identify all permissions settings and highlight those that vary from our required settings. To the extent that some grants can be revoked in between upgrades and not affect normal operations, the script could identify these areas.


  • Yes, I vote for this as well
    Oscar Sanchez