Database Administration (MOSC)

MOSC Banner

0ra-01927 revoke from public

edited Oct 25, 2018 12:37PM in Database Administration (MOSC) 7 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center