VERIFIED SOLUTION i

How to determine what permissions are required on a database in order to use it in MapInfo Pro?

Products affected: MapInfo Pro™
When users intend to use MapInfo Pro with a DBMS table the user will need to be able to read/write to the table in question and the MapInfo MapCatalog table. The MapCatalog table is used to stored information on the spatial tables and views.

If users intend to use EasyLoader to upload their resources:
  • Users will require administrator privileges to read and write to the database server. Even if they only read tables on the server, they still require write access to have EasyLoader create and then have MapInfo Pro write to the Map Catalog table.
  • EasyLoader will need to create a MAPINFO schema at the server level while creating the Map Catalog table.
  • EasyLoader will need to create a MAPINFO user for the database.
If users do not intend to use EasyLoader then Select privileges will need to be granted to all users on the MAPINFO_MAPCATALOG table. This allows users to make tables mappable. The Update, Insert, and Delete privileges must also be granted at the discretion of the database administrator.
UPDATED:  October 5, 2017