With the user SYS
it is required to revoke the privilege EXECUTE
of the table AWRRPT_HTML_TYPE
however when executing the statement
REVOKE EXECUTE ON AWRRPT_HTML_TYPE FROM PUBLIC;
Displays the following message:
ORA-01927: can not REVOKE privileges you did not grant
The privilege was given to the table with the sentence:
GRANT EXECUTE ON AWRRPT_HTML_TYPE TO PUBLIC;
Later it was executed:
REVOKE EXECUTE ON AWRRPT_HTML_TYPE FROM PUBLIC ;
And the message that came out was the following:
Revoke succeeded.
But when consulting it
SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE='PUBLIC' AND TABLE_NAME = 'AWRRPT_HTML_TYPE';
The privilege continues.
Oracle Version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0