This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,920 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

DB hardening Report

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

Tagged:
This discussion has been closed.