Difference between revisions of "APEX Granting Privileges to Database Users"
Jump to navigation
Jump to search
(Created page with "Here is the list (and syntax) of the privileges requires for APEX 4 workspace schema http://download.oracle.com/docs/cd/E17556_01/doc/user.40/e15517/priv_public.htm#CHDEDEIC Di...") |
|||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
− | Here is the list | + | 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 | http://download.oracle.com/docs/cd/E17556_01/doc/user.40/e15517/priv_public.htm#CHDEDEIC | ||
− | + | The direct grant is recommended. | |
− | [Category:APEX_Installation]] | + | <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]] |
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]