ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Creating the administrator users and connection in Oracle for the Workflow Manager workspace

Available with Workflow Manager license.

  • Creating the administrator geodatabase users
  • Creating the administrator database connection

Creating the administrator geodatabase users

The geodatabase users are underlying enterprise database users and store the Workflow Manager feature dataset and tables. You need to grant them the appropriate permissions.

For more information, see The geodatabase administrator in Oracle

The following scripts can be used in Oracle SQL Plus or Oracle SQL Developer to create a new database user to store the Workflow Manager feature classes and tables and grant the appropriate permissions.

Note:

Copying and pasting the example may cause syntax errors.

Create user and schema.

CREATE USER WMX PROFILE DEFAULT IDENTIFIED BY wmxadmin
	DEFAULT TABLESPACE "WMX_BDATA"
	TEMPORARY TABLESPACE "TEMP" 
	QUOTA UNLIMITED ON "WMX_BDATA"
	QUOTA UNLIMITED ON "WMX_BINDEX"
	QUOTA UNLIMITED ON "WMX_FDATA"
	QUOTA UNLIMITED ON "WMX_FINDEX"
	QUOTA UNLIMITED ON "WMX_SDATA"
	QUOTA UNLIMITED ON "WMX_SINDEX"
	QUOTA UNLIMITED ON "WMX_ADATA"
	QUOTA UNLIMITED ON "WMX_AINDEX"
	QUOTA UNLIMITED ON "WMX_DDATA"
	QUOTA UNLIMITED ON "WMX_DINDEX"
	ACCOUNT UNLOCK;

Grant privileges.

GRANT CREATE SESSION TO WMX;
GRANT CREATE SEQUENCE TO WMX;
GRANT CREATE TRIGGER TO WMX;
GRANT CREATE VIEW TO WMX;
GRANT CREATE TABLE TO WMX;

Creating the administrator database connection

You need to create an administrator database connection when the Workflow Manager workspace is stored in an enterprise geodatabase. Create a database connection in ArcCatalog with the Workflow Manager user; this will be the Workflow Manager workspace location.

For more information on database connections, see Database connections in ArcGIS for Desktop.

Related Topics

  • Database connections in ArcGIS for Desktop
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal