Creating the administrator users and connection in Oracle for the BIS workspace (Bathymetry Solution)

Creating the administrator geodatabase users

The geodatabase users are underlying enterprise database users and store the Bathymetry Information System (BIS) feature dataset and tables. You need to grant the users the appropriate permissions.

For more information, see The geodatabase administrator 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 BIS feature classes and tables and grant the appropriate permissions.

NoteNote:

Copying and pasting the examples may cause syntax errors.

Create user and schema:

CREATE USER BIS PROFILE DEFAULT IDENTIFIED BY bisadmin
	DEFAULT TABLESPACE "BIS_BDATA"
	TEMPORARY TABLESPACE "TEMP" 
	QUOTA UNLIMITED ON "BIS_BDATA"
	QUOTA UNLIMITED ON "BIS_BINDEX"
	QUOTA UNLIMITED ON "BIS_FDATA"
	QUOTA UNLIMITED ON "BIS_FINDEX"
	QUOTA UNLIMITED ON "BIS_SDATA"
	QUOTA UNLIMITED ON "BIS_SINDEX"
	QUOTA UNLIMITED ON "BIS_ADATA"
	QUOTA UNLIMITED ON "BIS_AINDEX"
	QUOTA UNLIMITED ON "BIS_DDATA"
	QUOTA UNLIMITED ON "BIS_DINDEX"
	QUOTA UNLIMITED ON "BIS_XMLDOC" 
	QUOTA UNLIMITED ON "BIS_XMLIDX"
	QUOTA UNLIMITED ON "BIS_RASTER" 
	QUOTA UNLIMITED ON "BIS_RINDEX"
	QUOTA UNLIMITED ON "BIS_RBLK" 
	QUOTA UNLIMITED ON "BIS_RBLKIDX"
	ACCOUNT UNLOCK;

Grant privileges:

GRANT CREATE SESSION TO BIS;
GRANT CREATE SEQUENCE TO BIS;
GRANT CREATE TRIGGER TO BIS;
GRANT CREATE VIEW TO BIS;
GRANT CREATE TABLE TO BIS;
GRANT EXECUTE ON ctx_ddl TO BIS;

Creating the administrator database connection

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

Related Topics

3/3/2014