ORA-01927 privilege is not revoked: can not REVOKE privileges you did not grant

2

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

    
asked by Cristian Zauco 21.02.2018 в 20:37
source

0 answers