APEX Granting Privileges to Database Users
Jump to navigation
Jump to search
Here is the list and syntax of the privileges required for APEX 4 workspace schema.
http://download.oracle.com/docs/cd/E17556_01/doc/user.40/e15517/priv_public.htm#CHDEDEIC
The direct grant is recommended.
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]