Oracle Error ORA-38470: cannot revoke a privilege that was not granted.

Oracle Error Message

ORA-38470: cannot revoke a privilege that was not granted.

Reason for the Error

An attempt was made to revoke a privilege that had not been granted.

Solution

Check catalog views to see if the user has the privilege.