Skip to content

GRANT EXECUTE on SYS Package to PUBLIC

  • by

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 *