Below are the privileges which needs to be revoked in QSRTPRG from PUBLIC. Please check with your team if these privileges are required to perform any application work. If not then you can raise CMP to GIDA team to revoke these privileges.
GRANTEE TABLE_NAME PRIVILEGE -------------------- ------------------------------ ----------------
PUBLIC UTL_TCP EXECUTE
PUBLIC UTL_SMTP EXECUTE
PUBLIC UTL_INADDR EXECUTE
PUBLIC UTL_HTTP EXECUTE
PUBLIC UTL_FILE EXECUTE
Eg:-
Revoke execute on SYS.UTL_TCP from PUBLIC;
Revoke execute on SYS.UTL_SMTP from PUBLIC;
Revoke execute on SYS.UTL_INADDR from PUBLIC;
Revoke execute on SYS.UTL_HTTP from PUBLIC;
Revoke execute on SYS.UTL_FILE from PUBLIC;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center