How to fix the Oracle error ORA-02186: tablespace resource privilege may not appear with other privileges?

In this post, you’ll learn more about the Oracle ErrorORA-02186: tablespace resource privilege may not appear with other privileges with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-02186: tablespace resource privilege may not appear with other privileges

Reason for the Error ORA-02186: tablespace resource privilege may not appear with other privileges

An attempt was made to grant or revoke a resource quota in the same statement in which other privileges are granted or revoked.

How to fix the Error ORA-02186: tablespace resource privilege may not appear with other privileges ?

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

Use a separate grant or revoke statement for the resource quota privilege.