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 10.2.0.2 and later
Information in this document applies to any platform.
Checked for relevance on 27-Mar-2017

Symptoms

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.

 

Cause

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