Difference between revisions of "APEX Granting Privileges to Database Users"
Jump to navigation
Jump to search
Line 4: | Line 4: | ||
The direct grant is recommended. | The direct grant is recommended. | ||
+ | |||
+ | <pre> | ||
+ | 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] | ||
+ | |||
+ | </pre> | ||
[[Category:APEX_Installation]] | [[Category:APEX_Installation]] | ||
+ | [[Category:APEX]] |
Latest revision as of 09:08, 15 August 2013
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]