错误码：-5571
错误内容：没有回收授权权限
错误级别: ERROR
原因：回收权限的用户不具有回收其他用户的权限

SQL> CREATE USER F1 IDENTIFIED BY 123456789;
SQL> CREATE USER F2 IDENTIFIED BY 123456789;
SQL> GRANT resource, public TO F1;
SQL> grant select ANY TABLE TO F2;
SQL> revoke select any table from f2;
revoke select any table from f2;
[-5571]:Error in line: 1
No revoke privilege.
used time: 1.318(ms). Execute id is 0.
SQL> 

解决方法
使用更高级别的用户进行回收, 或者授予 F1用户可以删除的权限

[dmdba@itsdata ~]$ disql SYSDBA/SYSDBA

Server[LOCALHOST:5236]:mode is normal, state is open
login used time : 3.303(ms)
disql V8
SQL> 
SQL> REVOKE SELECT ANY TABLE FROM F2;
executed successfully
used time: 12.917(ms). Execute id is 1200.
SQL>