Creating the administrator users and connection in Oracle for the 生产化制图 (Production Mapping) workspace (Production Mapping)

Creating the administrator geodatabase users

The geodatabase users are underlying enterprise database users and store the Esri Production Mapping feature dataset and tables. You need to grant the appropriate permissions.

Learn how to add users to an Oracle database

The following scripts can be used in Oracle SQL Plus or Oracle SQL Developer to create a new database user to store the 生产化制图 (Production Mapping) feature classes and tables and grant the appropriate permissions.

注:

Copying and pasting the example may cause syntax errors.

Create the user and schema.

CREATE USER PM PROFILE DEFAULT IDENTIFIED BY pmadmin
	DEFAULT TABLESPACE "PM_BDATA"
	TEMPORARY TABLESPACE "TEMP"
  QUOTA UNLIMITED ON "PM_BDATA" 
  QUOTA UNLIMITED ON "PM_BINDEX"
  QUOTA UNLIMITED ON "PM_FDATA" 
  QUOTA UNLIMITED ON "PM_FINDEX"
  QUOTA UNLIMITED ON "PM_SDATA" 
  QUOTA UNLIMITED ON "PM_SINDEX"
  QUOTA UNLIMITED ON "PM_ADATA" 
  QUOTA UNLIMITED ON "PM_AINDEX"
  QUOTA UNLIMITED ON "PM_DDATA" 
  QUOTA UNLIMITED ON "PM_DINDEX"
  QUOTA UNLIMITED ON "PM_XMLDOC" 
  QUOTA UNLIMITED ON "PM_XMLIDX"
  QUOTA UNLIMITED ON "PM_RASTER" 
  QUOTA UNLIMITED ON "PM_RINDEX"
  QUOTA UNLIMITED ON "PM_RBLK" 
  QUOTA UNLIMITED ON "PM_RBLKIDX"
  QUOTA UNLIMITED ON "PM_TOPO_BDATA" 
  QUOTA UNLIMITED ON "PM_TOPO_BINDEX"
  QUOTA UNLIMITED ON "PM_TOPO_FDATA" 
  QUOTA UNLIMITED ON "PM_TOPO_FINDEX"
  QUOTA UNLIMITED ON "PM_TOPO_SDATA" 
  QUOTA UNLIMITED ON "PM_TOPO_SINDEX"
  QUOTA UNLIMITED ON "PM_TERRAIN_BDATA" 
  QUOTA UNLIMITED ON "PM_TERRAIN_BINDEX"
  QUOTA UNLIMITED ON "PM_TERRAIN_FDATA" 
  QUOTA UNLIMITED ON "PM_TERRAIN_FINDEX"
  QUOTA UNLIMITED ON "PM_TERRAIN_SDATA" 
  QUOTA UNLIMITED ON "PM_TERRAIN_SINDEX"
  QUOTA UNLIMITED ON "PM_NET_BDATA" 
  QUOTA UNLIMITED ON "PM_NET_BINDEX"
  QUOTA UNLIMITED ON "PM_NET_FDATA" 
  QUOTA UNLIMITED ON "PM_NET_FINDEX"
  QUOTA UNLIMITED ON "PM_NET_SDATA" 
  QUOTA UNLIMITED ON "PM_NET_SINDEX"
  ACCOUNT UNLOCK;

Grant privileges.

CREATE ROLE "GIS_DATA_OWNER"  NOT IDENTIFIED;
GRANT CREATE SESSION TO "GIS_DATA_OWNER";
GRANT CREATE SEQUENCE TO "GIS_DATA_OWNER";
GRANT CREATE TRIGGER TO "GIS_DATA_OWNER";
GRANT CREATE VIEW TO "GIS_DATA_OWNER";
GRANT CREATE TABLE TO "GIS_DATA_OWNER";
GRANT GIS_DATA_OWNER TO PM;

Creating the administrator database connection

You need to create an administrator database connection when the 生产化制图 (Production Mapping) workspace is stored in an enterprise geodatabase. Create a database connection in ArcCatalog with the 生产化制图 (Production Mapping) user; this will be the 生产化制图 (Production Mapping) workspace location.

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