Revoking Privileges on SYS Package From PUBLIC Errors Out with ORA-1927
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
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
Million Knowledge Articles and hundreds of Community platforms