Hi Experts,
DB version 12.1.0.2
We have a package in apps schema.Not sure if some one provided access to this package to readonly schema(appsread).No developers are able to create packages in appsread user which should not happen.
when we try to revoke the privileges,it is throwing below error,so tried revoking any procedure but still appsread is able to create this package.
SQL> revoke debug on apps.XXFA_FA_MRT_NUM_GENERN_PKG from appsread;
revoke debug on apps.XXFA_FA_MRT_NUM_GENERN_PKG from appsread
*
ERROR at line 1:
ORA-01927: cannot REVOKE privileges you did not grant
SQL> revoke execute on apps.XXFA_FA_MRT_NUM_GENERN_PKG from appsread;
revoke debug on apps.XXFA_FA_MRT_NUM_GENERN_PKG from appsread
*
ERROR at line 1:
ORA-01927: cannot REVOKE privileges you did not grant
SQL> revoke execute any procedure from appsread;
Revoke succeeded.
But still user able to create this package using appsread
Thanks,
Kumar