Creating the administrator users and connection in Oracle for the Reviewer workspace

Creating the administrator geodatabase users

The geodatabase users are underlying enterprise database users and store the Reviewer 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 Reviewer feature classes and tables, and grant the appropriate permissions.

Note:

Copying and pasting the examples may cause syntax errors.

Create user and schema:

CREATE USER REV PROFILE DEFAULT IDENTIFIED BY rev
	DEFAULT TABLESPACE "REV_BDATA"
	TEMPORARY TABLESPACE "TEMP" 
	QUOTA UNLIMITED ON "REV_BDATA"
	QUOTA UNLIMITED ON "REV_BINDEX"
	QUOTA UNLIMITED ON "REV_FDATA"
	QUOTA UNLIMITED ON "REV_FINDEX"
	QUOTA UNLIMITED ON "REV_SDATA"
	QUOTA UNLIMITED ON "REV_SINDEX"
	QUOTA UNLIMITED ON "REV_ADATA"
	QUOTA UNLIMITED ON "REV_AINDEX"
	QUOTA UNLIMITED ON "REV_DDATA"
	QUOTA UNLIMITED ON "REV_DINDEX"
	ACCOUNT UNLOCK;

Grant privileges:

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

Creating the administrator database connection

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

Learn more about database connections in ArcGIS for Desktop.