Revoking Privileges on SYS Package From PUBLIC Errors Out with ORA-1927

(Doc ID 471863.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
Checked for relevance on 27-Mar-2017


When trying to revoke the EXECUTE privilege on a SYS package (eg: the UTL_FILE) package from PUBLIC user, the following error occurs:

ORA-01927: cannot REVOKE privileges you did not get grant.


This error is seen although one can see the grant to be removed in the DBA_TAB_PRIVS view. Example:

If DBA_TAB_PRIVS does not contain any privilege granted to PUBLIC on the package then the error is expected.



Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms