Minimum Roles / Access Controls for using Service Now as a Source

SOAP Web Service Access

The role soap_query must be granted to the user. This role grants execute access to SOAP web service resources.

Data Table Access

Precision Bridge will require the ability to read from all mapped tables. Therefore the source user connecting to Precision Bridge will need to have roles that include the ACL's that allow this. Note that read access must be granted for all records and fields that you wish to migrate.

Some roles (e.g snc_internal) may grant read access to these tables, but it is often limited to records created by the user.

System Table Access

In addition, the source user must have read access to the following tables to allow Precision Bridge to extract metadata:

• sys_db_object
• sys_dictionary
• sys_glide_object
• sys_choice

Note that access must be granted both to the table and all its fields.

If attachments are to be migrated from this source server to a target, the following table (and its fields) must have read access:

• sys_attachment

If currency/price fields are being mapped, these tables (and their fields) will also require read access:

• fx_price
• fx_currency_instance

If the target is a database (i.e an archiving use case), and you would like to use the Precision Bridge Archive Generation Wizard to create a db table with indexes that mirror those defined on the Service Now source table, the following table must have read access:

• v_db_index

Creation of Scripted Web Services

In certain use cases, Precision Bridge will attempt to create scripted web services on the source server to facilitate a particular piece of functionality. These web services are involved in supporting the following:

• For Service Now ->Database migrations to support the retrieval of the indexes defined on each form. This web service will only be required if the create indexes options are used in the Archive Generation Wizard.
• For Service Now -> Service Now migrations - The ID Replacement field mapping type
• For Service Now -> Database migrations  - Source Deletions are configured
• For Service Now migrations where the migration of attachments is required.

If  any of these areas of functionality are used, read/write access will be needed on the following tables to check if a web service exists (read access) and to create it if it does not (write access):

• sys_web_service
• sys_web_servcice_import
• sys_web_servcice_output

If read access only can be granted for the above tables, and you want to take advantage of Precision Bridge features that use web services, please contact Precision Bridge to obtain an updated set containing these web services.