Creating the administrator geodatabase users and connection in Oracle (Production Mapping)

Creating the administrator geodatabase users

The geodatabase users are underlying enterprise database users and store the product library feature classes and tables. You need to grant the appropriate permissions.

Learn how to add users to an Oracle database

For product library administrators, the following is suggested:

User type	Role	Oracle permissions
Data owner	CONNECT	CREATE PROCEDURE CREATE SEQUENCE CREATE SESSION CREATE TRIGGER CREATE VIEW CREATE TABLE

Administrator permissions

The following scripts can be used in Oracle to create a new database user to store the product library feature classes and tables and grant the appropriate permissions.

Remarque :

Copying and pasting the examples may cause syntax errors.

Create user and schema:

CREATE USER PRODLIB PROFILE DEFAULT IDENTIFIED BY prodlib
	DEFAULT TABLESPACE "PRODLIB_BDATA"
	TEMPORARY TABLESPACE "TEMP" 
	QUOTA UNLIMITED ON "PRODLIB_BDATA"
	QUOTA UNLIMITED ON "PRODLIB_BINDEX"
	QUOTA UNLIMITED ON "PRODLIB_FDATA"
	QUOTA UNLIMITED ON "PRODLIB_FINDEX"
	QUOTA UNLIMITED ON "PRODLIB_SDATA"
	QUOTA UNLIMITED ON "PRODLIB_SINDEX"
	QUOTA UNLIMITED ON "PRODLIB_ADATA"
	QUOTA UNLIMITED ON "PRODLIB_AINDEX"
	QUOTA UNLIMITED ON "PRODLIB_DDATA"
	QUOTA UNLIMITED ON "PRODLIB_DINDEX"
	ACCOUNT UNLOCK;

Grant privileges:

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

Creating the administrator database connection

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

Learn more about database connections in ArcGIS for Desktop.