Oracle Database Creation and Setup
When setting up an Oracle data source, review "Database Creation and Setup" in AssetWise Implementation Guide.
The following permissions are necessary for the newly-created Oracle user:
GRANT CONNECT TO NEW_USER with ADMIN OPTION; / GRANT RESOURCE TO NEW_USER with ADMIN OPTION; / GRANT CREATE ANY VIEW TO NEW_USER with ADMIN OPTION; / GRANT CREATE ANY SEQUENCE TO NEW_USER with ADMIN OPTION; / GRANT EXECUTE ON CTXSYS.CTX_DDL TO NEW_USER; /