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

Creating the administrator geodatabase users

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

For more information, see The geodatabase administrator in Oracle

For NIS 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

Note:

Additional permissions are required if the NIS administrator is also a user-schema geodatabase owner. For more information, see Privileges for geodatabases 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 NIS 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 NIS PROFILE DEFAULT IDENTIFIED BY nisadmin
	DEFAULT TABLESPACE "NIS_BDATA"
	TEMPORARY TABLESPACE "TEMP" 
	QUOTA UNLIMITED ON "NIS_BDATA"
	QUOTA UNLIMITED ON "NIS_BINDEX"
	QUOTA UNLIMITED ON "NIS_FDATA"
	QUOTA UNLIMITED ON "NIS_FINDEX"
	QUOTA UNLIMITED ON "NIS_SDATA"
	QUOTA UNLIMITED ON "NIS_SINDEX"
	QUOTA UNLIMITED ON "NIS_ADATA"
	QUOTA UNLIMITED ON "NIS_AINDEX"
	QUOTA UNLIMITED ON "NIS_DDATA"
	QUOTA UNLIMITED ON "NIS_DINDEX"
	QUOTA UNLIMITED ON "NIS_XMLDOC"
	QUOTA UNLIMITED ON "NIS_XMLINDEX"
	QUOTA UNLIMITED ON "NIS_SDEDICT"
	QUOTA UNLIMITED ON "NIS_SDEDICTINDEX"
	ACCOUNT UNLOCK;

Grant privileges:

CREATE ROLE "GIS_DATA_CREATOR" NOT IDENTIFIED;
GRANT CREATE SESSION TO "GIS_DATA_CREATOR";
GRANT CREATE SEQUENCE TO "GIS_DATA_CREATOR";
GRANT CREATE TRIGGER TO "GIS_DATA_CREATOR";
GRANT CREATE VIEW TO "GIS_DATA_CREATOR";
GRANT CREATE TABLE TO "GIS_DATA_CREATOR"; 
GRANT GIS_DATA_CREATOR TO NIS;

Creating the administrator database connection

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

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