Oracle Check Permissions Script does not report missing privileges (4377380)

The Check Permissions script used to validate Oracle permissions was inconsistently reporting results, sometimes returning "PL/SQL procedure successfully completed" when there were revoked or missing privileges. This behavior led to confusion when diagnosing missing advisory privileges, especially after revoking specific permissions such as DBA_USERS and V$ASM_DISK.

Steps to Reproduce:

1. Create a user (e.g., FOGLIGHT1) and grant appropriate Oracle permissions using the grant permissions script.

2. Revoke specific privileges (e.g., select on DBA_USERS, select on "V$ASM_DISK") from the user.

3. Run the Check Permissions script as the user to verify missing privileges.

Coding issue

WORKAROUND

Use the attached Check Permissions SQL script as a replacement in Oracle. The user should be logged into Supportlink to download the attachment.

STATUS

Defect ID FOG-9650 has been logged and will be fixed in the future release of the Oracle cartridge.