Hexagon Geospatial
MENU

ERDAS APOLLO Q&A

ERDAS APOLLO provides comprehensive data management and delivery which includes organizing geospatial and business data into a centralized library with cloud or on-premise distribution options.
Showing results for 
Search instead for 
Do you mean 

Create Oracle user schema for Apollo Catalog

by Technical Evangelist on ‎06-27-2017 04:06 AM (323 Views)

Make sure the default table space is “USERS” instead of “SYSTEM”, you will not be able to use “SYSTEM” tablespace at all.

user.jpg

 

So there is updated script that you can try:

 

 

 

CREATE USER [APOLLO_USER_NAME] IDENTIFIED BY [PASSWORD];
ALTER USER "[APOLLO_USER_NAME]" 
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK ;
GRANT RESOURCE, CONNECT, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE MATERIALIZED VIEW to [APOLLO_USER_NAME];
GRANT UNLIMITED TABLESPACE TO [APOLLO_USER_NAME];
COMMIT;

 

 

Contributors