Oracle DBA, How To, Error, Cause and Action

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

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.

No comments:

Post a Comment

Thanks for your comment.