Permissions

To use the Teradata spatial extension, the reader and writer will need to have permissions over certain tables of the database. To ensure the usability, the database user that is used for the transaction should have the following permissions:

  1. UDT Usage rights over the SYSUDTLIB database.
  2. Execute Function rights over the SYSSPATIAL database.
  3. Select and Insert rights on the SYSSPATIAL.spatial_ref_sys table.

For more information about permissions, consult Teradata documentation.