Creating the geodatabase NIS users and connections in Oracle

Creating an NIS editor user

The nis user created previously is a data owner. Anybody connecting as the owner can delete the NIS tables or make any schema changes. To protect the NIS, an editor user can be created to edit data. The examples below show how to create a geodatabase editor user to access the NIS.

Note:

Copying and pasting the examples may cause syntax errors.

CREATE USER NIS_EDITOR PROFILE "DEFAULT" 
	IDENTIFIED BY editor 
	DEFAULT TABLESPACE "USERS" 
	TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "NIS_EDITOR";
GRANT CREATE TABLE TO "NIS_EDITOR";
GRANT CREATE SEQUENCE TO "NIS_EDITOR";
GRANT "RLNISEDITOR" TO "NIS_EDITOR";  
/*-- RLNISEDITOR role has SELECT, INSERT, UPDATE and DELETE permission on the NIS data (feature classes, tables, etc.)
ALTER USER NIS_EDITOR QUOTA UNLIMITED ON "SDELOGFILE";
ALTER USER NIS_EDITOR QUOTA UNLIMITED ON "SDELOGFILEIDX";

Creating an NIS viewer user

Additionally, a viewer user can be created to provide read-only access to the NIS. The examples below show how to create a geodatabase viewer user to access the NIS.

Note:

Copying and pasting the examples may cause syntax errors.

CREATE USER NIS_VIEWER PROFILE "DEFAULT" 
	IDENTIFIED BY viewer
	DEFAULT TABLESPACE "USERS" 
	TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "NIS_VIEWER";
GRANT CREATE TABLE TO "NIS_VIEWER";
GRANT CREATE SEQUENCE TO "NIS_VIEWER";
GRANT "RLNISVIEWER" TO "NIS_VIEWER";  
/*-- RLNISVIEWER role has SELECT permission on the NIS data (feature classes, tables, etc.)
ALTER USER NIS_VIEWER QUOTA UNLIMITED ON "SDELOGFILE";
ALTER USER NIS_VIEWER QUOTA UNLIMITED ON "SDELOGFILEIDX";

Creating database connections for NIS users

Database connections need to be created for the other NIS users. Create a database connection in ArcCatalog with the NIS_EDITOR and NIS_VIEWER users.

For more information, see Database connections in ArcGIS for Desktop

Note:

You can create a login for each user in the NIS database and, if using database authentication, type the user name of the NIS user for whom you want to create a database connection.