Difference between revisions of "APEX Granting Privileges to Database Users"

From Ittichai Chammavanijakul's Wiki
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]
Retrieved from "https://ittichaicham.com/wiki/index.php?title=APEX_Granting_Privileges_to_Database_Users&oldid=1009"