0ra-01927 revoke from public
Does anybody have a work around for the error ORA-01927 cannot revoke privs you did not grant ?
I am trying to revoke execute on DBMS_SQL, UTL_FILE, ... from PUBLIC as the DISA STIG documents states to do.
revoke execute on UTL_FILE from public;
revoke execute on UTL_TCP from public;
revoke execute on UTL_SMTP from public;
revoke execute on UTL_HTTP from public;
revoke execute on DBMS_RANDOM from public;
revoke execute on DBMS_LOB from public;
revoke execute on DBMS_SQL from public;
revoke execute on DBMS_JOB from public;
--revoke execute on DBMS_BACKUP_RESTORE from public;