Skip to content
Home » Oracle » GRANT EXECUTE on SYS Package to PUBLIC

GRANT EXECUTE on SYS Package to PUBLIC

We used the following SQL statement to retrieve and compose necessary GRANT statements for you to fix your compiler problems related to SYS's public packages, such as PLS-00753 and PLS-00201.

SQL> select 'GRANT ' || privilege || ' ON ' || owner || '.' || table_name || ' TO ' || grantee || ';' stmt from dba_tab_privs where owner = 'SYS' and grantee = 'PUBLIC' and type = 'PACKAGE' order by 1;

There 260 packages of SYS should be granted to PUBLIC to EXECUTE.

GRANT EXECUTE ON SYS.DBMS_ADDM TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_ADVISOR TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_APPLICATION_INFO TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_APP_CONT_PRVT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQJMS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_EXP_CMT_TIME_TABLES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_EXP_DEQUEUELOG_TABLES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_EXP_HISTORY_TABLES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_EXP_INDEX_TABLES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_EXP_QUEUES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_EXP_QUEUE_TABLES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_EXP_SIGNATURE_TABLES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_EXP_SUBSCRIBER_TABLES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_EXP_TIMEMGR_TABLES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_IMP_INTERNAL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AQ_INV TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_ASH TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_ASSERT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AUTO_REPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AUTO_TASK TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AW TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AW_EXP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AW_STATS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_AW_XML TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_BLOCKCHAIN_TABLE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_COMPRESSION TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_CREDENTIAL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_CRYPTO_TOOLKIT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_CUBE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_CUBE_ADVISE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_CUBE_ADVISE_SEC TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_CUBE_EXP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_CUBE_LOG TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_CUBE_UTIL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DATAPUMP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DATA_MINING TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DATA_MINING_TRANSFORM TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DB_VERSION TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DDL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DEBUG TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP_CUSTOM TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DESCRIBE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DIMENSION TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DM_MODEL_EXP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_DM_MODEL_IMP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_EDITIONS_UTILITIES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_EDITIONS_UTILITIES2 TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_EPG TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_ERRLOG TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_FBT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_FILE_GROUP_EXP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_FILE_GROUP_IMP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_FREQUENT_ITEMSET TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_FUSE_PUBLIC TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_GOLDENGATE_EXP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_GOLDENGATE_IMP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_HEAT_MAP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_HIERARCHY TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_HS_PARALLEL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_ILM TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_IMMUTABLE_TABLE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_INDEX_UTL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_INMEMORY TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_ITRIGGER_UTL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_JAVA TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_JAVASCRIPT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_JOB TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_LCR TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_LDAP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_LDAP_UTL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_LOB TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_LOBUTIL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_LOGREP_EXP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_LOGREP_IMP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_LOGSTDBY_CONTEXT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_MDX_ODBO TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_MEMOPTIMIZE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_METADATA TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_METADATA_DIFF TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_MVIEW_STATS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_NETWORK_ACL_UTILITY TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_OBFUSCATION_TOOLKIT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_OBJECTS_UTILS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_ODCI TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_OUTPUT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_PARALLEL_EXECUTE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_PART TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_PCLXUTIL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_PICKLER TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_PLSQL_CODE_COVERAGE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_PREDICTIVE_ANALYTICS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_PREPROCESSOR TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_PROFILER TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_PSP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RANDOM TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_REFRESH TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_REPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RESOURCE_MANAGER TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RESOURCE_MANAGER_PRIVS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RESULT_CACHE_API TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RMGR_GROUP_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RMGR_PACT_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RMGR_PLAN_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RMIN TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_ROWID TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RULE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RULEADM_INTERNAL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RULE_ADM TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RULE_EXP_EV_CTXS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RULE_EXP_RULES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RULE_EXP_RULE_SETS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RULE_EXP_UTLI TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_RULE_IMP_OBJ TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHEDULER TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_ATTRIBUTE_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_CHAIN_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_CLASS_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_CONSTRAINT_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_CREDENTIAL_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_EXPORT_CALLOUTS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_FILE_WATCHER_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_JOB_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_PROGRAM_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_SCHEDULE_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_WINDOW_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCHED_WINGRP_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SCN TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SESSION TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SNAPSHOT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SNAPSHOT_UTL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SODA TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SPACE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SPD TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SPM TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQLDIAG TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQLPA TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQLQ TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQLSET TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQLTUNE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQLTUNE_UTIL2 TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQL_MONITOR TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQL_TRANSLATOR TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SQL_TRANSLATOR_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_STANDARD TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_STATS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_STATS_ADVISOR TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_STATS_INTERNAL_AGG TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_STAT_FUNCS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_STAT_FUNCS_AUX TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_STREAMS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_STREAMS_PUB_RPC TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SUMMARY TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SUM_RWEQ_EXPORT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_SYNC_REFRESH TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_TABLE_DATA TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_TF TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_TRACE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_TRANSACTION TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_TRANSFORM_EXIMP TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_TYPES TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_USER_CERTS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_UTILITY TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_WARNING TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XA TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XMLGEN TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XMLQUERY TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XMLSAVE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XMLSCHEMA_UTIL TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XMLSTORE TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XPLAN TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XQUERY TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XQUERYINT TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_XS_SESSIONS TO PUBLIC;
GRANT EXECUTE ON SYS.DBMS_ZHELP_IR TO PUBLIC;
GRANT EXECUTE ON SYS.DIUTIL TO PUBLIC;
GRANT EXECUTE ON SYS.GENCONNECTIONINTERFACE TO PUBLIC;
GRANT EXECUTE ON SYS.GENCURSORMANAGERINTERFACE TO PUBLIC;
GRANT EXECUTE ON SYS.GENDATABASEINTERFACE TO PUBLIC;
GRANT EXECUTE ON SYS.GENDATAPROVIDERINTERFACE TO PUBLIC;
GRANT EXECUTE ON SYS.GENDATATYPEIDCONSTANTS TO PUBLIC;
GRANT EXECUTE ON SYS.GENDEFINITIONMANAGERINTERFACE TO PUBLIC;
GRANT EXECUTE ON SYS.GENMDMCLASSCONSTANTS TO PUBLIC;
GRANT EXECUTE ON SYS.GENMDMOBJECTIDCONSTANTS TO PUBLIC;
GRANT EXECUTE ON SYS.GENMDMPROPERTYIDCONSTANTS TO PUBLIC;
GRANT EXECUTE ON SYS.GENMETADATAPROVIDERINTERFACE TO PUBLIC;
GRANT EXECUTE ON SYS.GENSERVERINTERFACE TO PUBLIC;
GRANT EXECUTE ON SYS.GET_ERROR$ TO PUBLIC;
GRANT EXECUTE ON SYS.HTF TO PUBLIC;
GRANT EXECUTE ON SYS.HTP TO PUBLIC;
GRANT EXECUTE ON SYS.JAVA_XA TO PUBLIC;
GRANT EXECUTE ON SYS.JVMRJBC TO PUBLIC;
GRANT EXECUTE ON SYS.JVMRJBCINV TO PUBLIC;
GRANT EXECUTE ON SYS.KUBSAGT TO PUBLIC;
GRANT EXECUTE ON SYS.KUBSD$DESC_INT TO PUBLIC;
GRANT EXECUTE ON SYS.KUPCC TO PUBLIC;
GRANT EXECUTE ON SYS.KUPF$FILE TO PUBLIC;
GRANT EXECUTE ON SYS.KUPM$MCP TO PUBLIC;
GRANT EXECUTE ON SYS.KUPU$UTILITIES TO PUBLIC;
GRANT EXECUTE ON SYS.KUPW$WORKER TO PUBLIC;
GRANT EXECUTE ON SYS.LBAC_EXP TO PUBLIC;
GRANT EXECUTE ON SYS.ODCICONST TO PUBLIC;
GRANT EXECUTE ON SYS.ODM_UTIL TO PUBLIC;
GRANT EXECUTE ON SYS.OJDS_NAMESPACE TO PUBLIC;
GRANT EXECUTE ON SYS.ORA_DM_REFCUR_PKG TO PUBLIC;
GRANT EXECUTE ON SYS.OWA TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_CACHE TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_COOKIE TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_CUSTOM TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_IMAGE TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_MATCH TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_OPT_LOCK TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_PATTERN TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_SEC TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_TEXT TO PUBLIC;
GRANT EXECUTE ON SYS.OWA_UTIL TO PUBLIC;
GRANT EXECUTE ON SYS.PBSDE TO PUBLIC;
GRANT EXECUTE ON SYS.PLITBLM TO PUBLIC;
GRANT EXECUTE ON SYS.PRIVATE_JDBC TO PUBLIC;
GRANT EXECUTE ON SYS.PRVTEMX_SQL TO PUBLIC;
GRANT EXECUTE ON SYS.PRVT_AWR_DATA TO PUBLIC;
GRANT EXECUTE ON SYS.PRVT_AWR_DATA_CP TO PUBLIC;
GRANT EXECUTE ON SYS.PRVT_COMPRESSION TO PUBLIC;
GRANT EXECUTE ON SYS.PRVT_CPADDM TO PUBLIC;
GRANT EXECUTE ON SYS.PRVT_REPORT_TAGS TO PUBLIC;
GRANT EXECUTE ON SYS.PRVT_RTADDM TO PUBLIC;
GRANT EXECUTE ON SYS.SQLJUTL TO PUBLIC;
GRANT EXECUTE ON SYS.STANDARD TO PUBLIC;
GRANT EXECUTE ON SYS.URIFACTORY TO PUBLIC;
GRANT EXECUTE ON SYS.USER_LOCK TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_CALL_STACK TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_COLL TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_COMPRESS TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_ENCODE TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_FILE TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_GDK TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_HTTP TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_I18N TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_IDENT TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_INADDR TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_LMS TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_MATCH TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_NLA TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_RAW TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_REF TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_SMTP TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_TCP TO PUBLIC;
GRANT EXECUTE ON SYS.UTL_URL TO PUBLIC;
GRANT EXECUTE ON SYS.WPG_DOCLOAD TO PUBLIC;
GRANT EXECUTE ON SYS.WPIUTL TO PUBLIC;
GRANT EXECUTE ON SYS.XS_ACL TO PUBLIC;
GRANT EXECUTE ON SYS.XS_ADMIN_UTIL TO PUBLIC;
GRANT EXECUTE ON SYS.XS_DATA_SECURITY TO PUBLIC;
GRANT EXECUTE ON SYS.XS_DIAG TO PUBLIC;
GRANT EXECUTE ON SYS.XS_NAMESPACE TO PUBLIC;
GRANT EXECUTE ON SYS.XS_PRINCIPAL TO PUBLIC;
GRANT EXECUTE ON SYS.XS_ROLESET TO PUBLIC;
GRANT EXECUTE ON SYS.XS_SECURITY_CLASS TO PUBLIC;

If there's any error during execution, inspect and record them for later debug.

Leave a Reply

Your email address will not be published. Required fields are marked *