How to fix the Oracle error ORA-01939: only the ADMIN OPTION can be specified?

In this post, you’ll learn more about the Oracle ErrorORA-01939: only the ADMIN OPTION can be specified with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01939: only the ADMIN OPTION can be specified

Reason for the Error ORA-01939: only the ADMIN OPTION can be specified

System privileges and Roles can only be granted with the admin option. The grant option cannot be used with these privileges.

How to fix the Error ORA-01939: only the ADMIN OPTION can be specified ?

You can fix this error in Oracle by following the below steps

Specify the admin option.