DB hardening Report

user12992644

I'm doing Database harderning report for oracle 11G

So I'm executing below select query to check whether public grantee present or not?

SELECT GRANTEE, TABLE_NAME FROM DBA_TAB_PRIVS where TABLE_NAME='DBMS_ADVISOR' AND GRANTEE ='PUBLIC';

My expected result is "No rows selected". But its giving result like below

GRANTEE

TABLE_NAME

------------------------------ ------------------------------

PUBLIC

DBMS_ADVISOR

So I revoke the Public grantee permission like below

revoke execute on DBMS_ADVISOR from public;

Its throwing below error

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-16000: database open for read-only access

Any body please help me how to resolve the ORA-00604: and ORA-16000:  errors?

Advance Thanks,

Karthick