PROXY CREATION

BC Geographic Warehouse (BCGW) and non-BCGW proxies are created as a means for applications to access the data, as individual Oracle accounts are not permitted to be used in this manner. Proxies will only be created for and used by the application that they were intended.

This page provides standards for creating proxy accounts. Out of scope, at this time, is the Request for Proxy Account process.

AUDIENCE
Data Publishers

Table of Contents


PROXY ACCOUNT NAMING CONVENTIONS

To facilitate streamlined management and notification, proxy accounts will conform to the following naming conventions:

Internal Proxy Accounts

Proxy accounts created for internal DataBC applications will follow the pattern:

“PROXY_TYPE_APPNAME”

Where:

TYPE reflects the type of application making the call to the DB:

Type Requester
AGS – ArcGIS Server application Web mapping
AGSDYNA - ArcGIS Server connection for dynamic requests using MPCM Web mapping
ESS – Geocortex Essentials application Web mapping
JAVA – Java application Business Analysis
FME – FME application ETL
WMS – Mapserver application Web mapping
GEO – Geoserver application Web mapping
RPT - Jasper Reports application As required
SCRIPT - A script rather than an application (Python, AML etc.) As required

APPNAME is the standard application or web service name

If the account is intended to be temporary (e.g. to support a standalone mapservice referenced by a straw man IMF2 site that will never go to Production) then please append TEMP to the end of the account name.

External Proxy Accounts

Proxies created for applications external to DataBC will follow the pattern:

“PROXY_ORG_TYPE_APPNAME”

Where:

ORG is the ministry level organization that is responsible for the application (i.e. FLNRO, JTST) TYPE reflects the type of application making the call to the DB:

  • FME – FME application
  • JAVA – Java application
  • NET - .NET application
  • WMS – Mapserver application
  • GEO – Geoserver application
  • SCRIPT - A script rather than an application (Python, AML etc.)

APPNAME is the standard application or web service name

If the account is intended to be temporary then please append TEMP to the end of the account name.

Proxy Terms of Use

Business areas will apply the following guidelines. Failure to do so, will result in accounts being subject to freezing and/or deletion.

Appropriate Use

  • Proxy will be implemented as documented in the request
  • Proxy will not be repurposed or shared with other applications or processes
  • DataBC will provide a single BC Government representative with proxy account passwords for use as documented in the request. The proxy password may not be distributed beyond those specifically required to use the password for application configuration.
  • Best practices will be implemented for proxy account management (i.e. passwords updated on regular cycle)

Application Schema Requests

In the event that a net new application schema is required the creation scripts should be supplied as part of the application migration. These scripts will be reviewed by the business area and the DAs to confirm that the requested parameters meet the structure and naming standards of DataBC. Once the kit has passed this initial review it will be sent to the DBAs for final review and creation.

Change Management

  • DataBC will be informed of changes to the application environment, including but not limited to:
    • Server/hardware changes
    • Usage/access patterns
    • Software changes
  • Attendance of a delegate at DataBC change coordination meeting to inform of changes
  • Upon application retirement, a request will be sent to DataBC to request decommissioning of proxy
  • Change Management notifications will be received by DataBC no less than 90 days before the date of anticipated change

RETURN TO TOP