Available with Production Mapping license.
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.
For more information, see The geodatabase administrator in Oracle
For product library administrators, the following is suggested:
User type | Role | Oracle permissions |
---|---|---|
Data owner | CONNECT |
|
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.
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"
QUOTA UNLIMITED ON "PRODLIB_XMLDOC"
QUOTA UNLIMITED ON "PRODLIB_XMLINDEX"
QUOTA UNLIMITED ON "PRODLIB_SDEDICT"
QUOTA UNLIMITED ON "PRODLIB_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 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.
For more information, see Database connections in ArcGIS for Desktop.