Pitney Bowes MapXtreme - Manual (Page 231)

Chapter 11: Accessing Data from a DBMS
The MapInfo_MapCatalog
MapXtreme v7.1 238 Developer Guide
NUMBER_ROWS INTEGER
)
L
It is important that the structure of the table looks exactly like this statement. The only
substitution that can be made is for databases that support varchar or text data types;
these data types can be substituted for the Char data type.
3. Create a unique index on the TABLENAME and the OWNERNAME, so only one table for each
owner can be made mappable.
create unique index mapcat_i1
on mapinfo.mapinfo_mapcatalog (OwnerName,TableName)
4. Grant Select, Update, Insert, and Delete privileges on the MAPINFO_MAPCATALOG. This
allows users to make tables mappable.
grant select, insert, update, delete on mapinfo.mapinfo_mapcatalog to
public