Skip to content

SYS Packages Granted to Public

  • by

For your reference, here I list packages owned by SYS, which should be granted with EXECUTE privilege to PUBLIC in 19c.

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

Please note that, USER_LOCK is not a default package, it needs to be installed.

Leave a Reply

Your email address will not be published.