Previous Next JavaScript must be enabled to correctly display this content

## F About Granted Privileges

Learn about grant privileges in Oracle APEX.

- About Granting Privileges to Database Users
  Review granted privileges Oracle recommends for database users.
- Understanding Privileges Granted to PUBLIC
  Learn about privileges granted to PUBLIC.

### F.1 About Granting Privileges to Database Users

Review granted privileges Oracle recommends for database users.

In APEX, no privileges are granted to database users when creating a workspace on an existing schema. Unless direct grants exist, database users in APEX will not be able to create tables or other database objects. To allow the creation of typical database objects, Oracle recommends the following list of directly granted privileges

`grant CREATE SESSION to [database username]`

`grant CREATE CLUSTER to [database username]`

`grant CREATE DIMENSION to [database username]`

`grant CREATE INDEXTYPE to [database username]`

`grant CREATE JOB to [database username]`

`grant CREATE MATERIALIZED VIEW to [database username]`

`grant CREATE OPERATOR to [database username]`

`grant CREATE PROCEDURE to [database username]`

`grant CREATE SEQUENCE to [database username]`

`grant CREATE SNAPSHOT to [database username]`

`grant CREATE SYNONYM to [database username]`

`grant CREATE TABLE to [database username]`

`grant CREATE TRIGGER to [database username]`

`grant CREATE TYPE to [database username]`

`grant CREATE VIEW to [database username]`

Parent topic: About Granted Privileges

### F.2 Understanding Privileges Granted to PUBLIC

Learn about privileges granted to PUBLIC.

This section describes public synonyms that exist and for which the execute privilege is granted to `PUBLIC` for the packages, procedures, functions, tables, and views owned by the APEX product schema, (for example, `APEX_260100`).

Tip:

To avoid conflicts with operation of the APEX engine, Oracle recommends not using the following names for database objects in schemas associated with Oracle APEX workspaces.

- Packages
- Procedures
- Functions
- Tables
- Views
- Sequences
- Types

Parent topic: About Granted Privileges

#### F.2.1 Packages

Public synonyms exist and execute privilege is granted to `PUBLIC` for the following packages owned by the APEX product schema, (for example, `APEX_260100`):

`APEXWS`

`APEX_MIG_PROJECTS_UPDATE`

`APEX_UI_DEFAULT_UPDATE`

`HTMLDB_CUSTOM_AUTH`

`HTMLDB_ITEM`

`HTMLDB_LANG`

`HTMLDB_SITE_ADMIN_PRIVS`

`WWV_FLOW_APPLICATION_INSTALL`

`HTMLDB_UTIL`

`WWV_FLOW`

`WWV_FLOW_API`

`WWV_FLOW_AUDIT`

`WWV_FLOW_CSS_API`

`WWV_FLOW_APPLICATION_INSTALL`

`WWV_FLOW_AUDIT`

`WWV_FLOW_COLLECTION`

`WWV_FLOW_CSS`

`WWV_FLOW_CSS_API`

`WWV_FLOW_CUSTOMIZE`

`WWV_FLOW_CUSTOM_AUTH`

`WWV_FLOW_CUSTOM_AUTH_LDAP`

`WWV_FLOW_CUSTOM_AUTH_STD`

`WWV_FLOW_DEBUG_MESSAGE`

`WWV_FLOW_EPG_INCLUDE_MODULES`

`WWV_FLOW_FILE_MGR`

`WWV_FLOW_FND_USER_API`

`WWV_FLOW_GLOBAL`

`WWV_FLOW_HINT`

`WWV_FLOW_HTML_API`

`WWV_FLOW_ID`

`WWV_FLOW_IMAGE_API`

`WWV_FLOW_ITEM`

`WWV_FLOW_ITEM_HELP`

`WWV_FLOW_JAVASCRIPT`

`WWV_FLOW_LANG`

`WWV_FLOW_LDAP`

`WWV_FLOW_LOOKUP_TABLES`

`WWV_FLOW_MAIL`

`WWV_FLOW_PLSQL_JOB`

`WWV_FLOW_PLUGIN`

`WWV_FLOW_PLUGIN_UTIL`

`WWV_FLOW_PREFERENCES`

`WWV_FLOW_RANDOM`

`WWV_FLOW_RENDER_SHORTCUT`

`WWV_FLOW_REST`

`WWV_FLOW_SVG`

`WWV_FLOW_USER_API`

`WWV_FLOW_UTILITIES`

`WWV_FLOW_WEBSERVICES_API`

`WWV_FLOW_WS_IMPORT_API`

`WWV_MIG_ACC_LOAD`

`WWV_RENDER_CALENDAR2`

`WWV_RENDER_CHART2`

Execute privilege is granted to `PUBLIC` for the following packages owned by the APEX product schema, (for example, `APEX_260100`):

`WWV_CALCULATOR`

`WWV_FLOW_FLASH_CHART`

`WWV_FLOW_GENERATE_DDL`

`WWV_FLOW_IMAGE_GENERATOR`

`WWV_FLOW_TREE_GLOBAL_VARS`

Parent topic: Understanding Privileges Granted to PUBLIC

#### F.2.2 Procedures

Public synonyms exist and execute privilege is granted to `PUBLIC` for the following procedures owned by the Oracle APEX product schema, (for example, `APEX_260100`):

`APEX`

`APEX_ADMIN`

`DEVELOPMENT_SERVICE_HOME`

`DEVELOPMENT_SERVICE_HOME_LOGIN`

`DEVELOPMENT_SERVICE_SIGNUP`

`F`

`HTMLDB`

`HTMLDB_ADMIN`

`HTMLDB_LOGIN`

`P`

`WS`

`WWV_FLOW_INIT_HTP_BUFFER`

`Z`

Parent topic: Understanding Privileges Granted to PUBLIC

#### F.2.3 Functions

Public synonyms exist and execute privilege is granted to `PUBLIC` for the following functions owned by the Oracle APEX product schema, (for example, `APEX_260100`):

`NV`

`V`

Execute privilege is granted to `PUBLIC` for the following function owned by the APEX product schema (for example, `APEX_260100`):

`WWV_POPUP_FILTER`

Parent topic: Understanding Privileges Granted to PUBLIC

#### F.2.4 Tables

Public synonyms exist and select privilege is granted to `PUBLIC` for the following tables owned by the Oracle APEX product schema, (for example, `APEX_260100`):

`WWV_FLOW_DUAL100`

`WWV_FLOW_TEMP_TABLE`

`WWV_FLOW_LOV_TEMP`

Parent topic: Understanding Privileges Granted to PUBLIC

#### F.2.5 Views

Public synonyms exist and select privilege is granted to `PUBLIC` for the following views owned by the Oracle APEX product schema (for example, `APEX_260100`):

`APEX_APPLICATIONS`

`APEX_APPLICATION_ALL_AUTH`

`APEX_APPLICATION_AUTH`

`APEX_APPLICATION_AUTHORIZATION`

`APEX_APPLICATION_BC_ENTRIES`

`APEX_APPLICATION_BREADCRUMBS`

`APEX_APPLICATION_BUILD_OPTIONS`

`APEX_APPLICATION_CACHING`

`APEX_APPLICATION_COMPUTATIONS`

`APEX_APPLICATION_GROUPS`

`APEX_APPLICATION_ITEMS`

`APEX_APPLICATION_LISTS`

`APEX_APPLICATION_LIST_ENTRIES`

`APEX_APPLICATION_LOVS`

`APEX_APPLICATION_LOV_ENTRIES`

`APEX_APPLICATION_NAV_BAR`

`APEX_APPLICATION_PAGES`

`APEX_APPLICATION_PAGE_BRANCHES`

`APEX_APPLICATION_PAGE_BUTTONS`

`APEX_APPLICATION_PAGE_CHARTS`

`APEX_APPLICATION_PAGE_CHART_S`

`APEX_APPLICATION_PAGE_CHART_A`

`APEX_APPLICATION_PAGE_COMP`

`APEX_APPLICATION_PAGE_DA`

`APEX_APPLICATION_PAGE_DA_ACTS`

`APEX_APPLICATION_PAGE_DB_ITEMS`

`APEX_APPLICATION_PAGE_FLASH5`

`APEX_APPLICATION_PAGE_FLASH5_S`

`APEX_APPLICATION_PAGE_GROUPS`

`APEX_APPLICATION_PAGE_IR`

`APEX_APPLICATION_PAGE_IR_CAT`

`APEX_APPLICATION_PAGE_IR_CGRPS`

`APEX_APPLICATION_PAGE_IR_COL`

`APEX_APPLICATION_PAGE_IR_COMP`

`APEX_APPLICATION_PAGE_IR_COND`

`APEX_APPLICATION_PAGE_IR_GRPBY`

`APEX_APPLICATION_PAGE_IR_PIVOT`

`APEX_APPLICATION_PAGE_IR_PVAGG`

`APEX_APPLICATION_PAGE_IR_PVSRT`

`APEX_APPLICATION_PAGE_IR_RPT`

`APEX_APPLICATION_PAGE_IR_SUB`

`APEX_APPLICATION_PAGE_ITEMS`

`APEX_APPLICATION_PAGE_MAP`

`APEX_APPLICATION_PAGE_PROC`

`APEX_APPLICATION_PAGE_REGIONS`

`APEX_APPLICATION_PAGE_RPT`

`APEX_APPLICATION_PAGE_RPT_COLS`

`APEX_APPLICATION_PAGE_TREES`

`APEX_APPLICATION_PAGE_VAL`

`APEX_APPLICATION_PARENT_TABS`

`APEX_APPLICATION_PROCESSES`

`APEX_APPLICATION_RPT_LAYOUTS`

`APEX_APPLICATION_RPT_QRY_STMTS`

`APEX_APPLICATION_RPT_QUERIES`

`APEX_APPLICATION_SETTINGS`

`APEX_APPLICATION_SHORTCUTS`

`APEX_APPLICATION_SUBSTITUTIONS`

`APEX_APPLICATION_SUPP_OBJECTS`

`APEX_APPLICATION_SUPP_OBJ_BOPT`

`APEX_APPLICATION_SUPP_OBJ_CHCK`

`APEX_APPLICATION_SUPP_OBJ_SCR`

`APEX_APPLICATION_TABS`

`APEX_APPLICATION_TEMPLATES`

`APEX_APPLICATION_TEMP_BC`

`APEX_APPLICATION_TEMP_BUTTON`

`APEX_APPLICATION_TEMP_CALENDAR`

`APEX_APPLICATION_TEMP_LABEL`

`APEX_APPLICATION_TEMP_LIST`

`APEX_APPLICATION_TEMP_PAGE`

`APEX_APPLICATION_TEMP_POPUPLOV`

`APEX_APPLICATION_TEMP_REGION`

`APEX_APPLICATION_TEMP_REPORT`

`APEX_APPLICATION_THEMES`

`APEX_APPLICATION_TRANSLATIONS`

`APEX_APPLICATION_TRANS_MAP`

`APEX_APPLICATION_TREES`

`APEX_APPLICATION_WEB_SERVICES`

`APEX_APPL_ACL_ROLES`

`APEX_APPL_ACL_USER_ROLES`

`APEX_APPL_ACL_USERS`

`APEX_APPL_PAGE_IG_COLUMNS`

`APEX_APPL_PAGE_IG_COL_GROUPS`

`APEX_APPL_PAGE_IGS`

`APEX_APPL_PAGE_IG_RPTS`

`APEX_APPL_PAGE_IG_RPT_VIEWS`

`APEX_APPL_PAGE_IG_RPT_COMPUTES`

`APEX_APPL_PAGE_IG_RPT_FILTERS`

`APEX_APPL_PAGE_IG_RPT_COLUMNS`

`APEX_APPL_PAGE_IG_RPT_HIGHLTS`

`APEX_APPL_PAGE_IG_RPT_AGGS`

`APEX_APPL_PAGE_IG_RPT_CHT_COLS`

`APEX_APPL_PLUGINS`

`APEX_APPL_PLUGIN_ATTRIBUTES`

`APEX_APPL_PLUGIN_ATTR_VALUES`

`APEX_APPL_PLUGIN_EVENTS`

`APEX_APPL_PLUGIN_FILES`

`APEX_DEBUG_MESSAGES`

`APEX_DEVELOPER_ACTIVITY_LOG`

`APEX_DICTIONARY`

`APEX_DG_BLUEPRINT_SAMPLES`

`APEX_DG_META_TAB_COL_EXAMPLES`

`APEX_PATCHES`

`APEX_PKG_APP_ACTIVITY`

`APEX_PKG_APP_AUTHENTICATIONS`

`APEX_PKG_APPS`

`APEX_RELEASE`

`APEX_STANDARD_CONDITIONS`

`APEX_TEAM_BUGS`

`APEX_TEAM_FEEDBACK`

`APEX_TEAM_MILESTONES`

`APEX_TEAM_TODOS`

`APEX_THEMES`

`APEX_UI_DEFAULTS_ATTR_DICT`

`APEX_UI_DEFAULTS_COLUMNS`

`APEX_UI_DEFAULTS_GROUPS`

`APEX_UI_DEFAULTS_LOV_DATA`

`APEX_UI_DEFAULTS_TABLES`

`APEX_WORKSPACES`

`APEX_WORKSPACE_ACCESS_LOG`

`APEX_WORKSPACE_ACTIVITY_LOG`

`APEX_WORKSPACE_APEX_USERS`

`APEX_WORKSPACE_CLICKS`

`APEX_WORKSPACE_DEVELOPERS`

`APEX_WORKSPACE_FILES`

`APEX_WORKSPACE_LOG_SUMMARY`

`APEX_WORKSPACE_LOG_SUMMARY_USR`

`APEX_WORKSPACE_SCHEMAS`

`APEX_WORKSPACE_SESSIONS`

`APEX_WORKSPACE_SQL_SCRIPTS`

`APEX_WS_APPLICATIONS`

`APEX_WS_APP_PAGES`

`APEX_WS_DATA_GRID`

`APEX_WS_DATA_GRID_COL`

`WWV_FLOW_CLICKTHRU_LOG`

`WWV_FLOW_COLLECTIONS`

`WWV_FLOW_FEEDBACK_TYPES`

`WWV_FLOW_GROUP_USERS`

`WWV_FLOW_LISTS_OF_VALUES$_V`

`WWV_FLOW_LIST_OF_VALUES_DATA_V`

`WWV_FLOW_MONTHS_MON`

`WWV_FLOW_MONTHS_MONTH`

`WWV_FLOW_PLSQL_JOBS`

`WWV_FLOW_USERS`

`WWV_FLOW_USER_ACCESS_LOG`

`WWV_FLOW_USER_ACTIVITY_LOG`

`WWV_FLOW_USER_MAIL_LOG`

`WWV_FLOW_YEARS`

Additionally, insert is granted on the following:

`WWV_FLOW_FILES`

Additionally, the following views have select privilege granted to `PUBLIC`, but no synonym:

`WWV_FLOW_HOURS_12`

`WWV_FLOW_HOURS_24`

`WWV_FLOW_MINUTES`

`WWV_FLOW_MINUTES_5`

Parent topic: Understanding Privileges Granted to PUBLIC

#### F.2.6 Sequences

The following sequences have public synonyms and select privilege granted to public:

`WWV_FLOW_SESSION_SEQ`

`WWV_SEQ`

Parent topic: Understanding Privileges Granted to PUBLIC

#### F.2.7 Types

The following types have execute granted to public but no synonyms:

`WWV_FLOW_TREE_ENTRY`

`WWV_FLOW_TREE_SUBS`

Parent topic: Understanding Privileges Granted to PUBLIC