Oracle DBA, How To, Error, Cause and Action

ORA-02186: tablespace resource privilege may not appear with otherprivileges

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




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




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