Spatial Support Privilege Summary

A list of the system privileges and object permissions required to complete the various spatial support tasks.

Creating a Spatial Reference System

Database Version Spatial Reference System Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group.
SAP Sybase IQ 16.0 Requires one of:
  • MANAGE ANY SPATIAL OBJECT system privilege.
  • CREATE ANY OBJECT system privilege.

Deleting a Spatial Reference System

Database Version Spatial Reference System Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.

  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group.
SAP Sybase IQ 16.0 Requires one of:
  • MANAGE ANY SPATIAL OBJECT system privilege.
  • DROP ANY OBJECT system privilege.

Generating Spatial Reference System DDL Commands

Database Version Spatial Reference System Privileges
SAP Sybase IQ 15.3 and 15.4 None required.
SAP Sybase IQ 16.0 None required.

Viewing or Modifying Spatial Reference System Properties

Database Version Spatial Reference System Privileges
SAP Sybase IQ 15.3 and 15.4

View spatial reference system properties – None required.

Modify spatial reference system properties or comments – Requires one of:

  • DBA authority.

  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group.
SAP Sybase IQ 16.0

View spatial reference system properties – None required.

Modify spatial reference system properties – Requires one of:
  • MANAGE ANY SPATIAL OBJECT system privilege.
  • ALTER ANY OBJECT system privilege.
Modify spatial reference system comment – Requires one of:
  • COMMENT ANY OBJECT system privilege.
  • CREATE ANY OBJECT system privilege.
  • ALTER ANY OBJECT system privilege.
  • MANAGE ANY SPATIAL OBJECT system privilege.

Creating a Spatial Unit of Measure

Database Version Spatial Unit of Measure Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group.
SAP Sybase IQ 16.0 Requires one of:
  • CREATE ANY OBJECT system privilege.
  • MANAGE ANY SPATIAL OBJECT.

Deleting a Spatial Unit of Measure

Database Version Spatial Unit of Measure Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.

  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group.
SAP Sybase IQ 16.0 Requires one of:
  • MANAGE ANY SPATIAL OBJECT system privilege.
  • DROP ANY OBJECT system privilege.

Generating Spatial Unit of Measure DDL Commands

Database Version Spatial Unit of Measure Privileges
SAP Sybase IQ 15.3 and 15.4 None required.
SAP Sybase IQ 16.0 None required.

Viewing or Modifying Spatial Unit of Measure Properties

Database Version Spatial Unit of Measure Privileges
SAP Sybase IQ 15.3 and 15.4

View spatial unit of measure properties – None required.

Modify spatial unit of measure properties or comments – Requires one of:

  • DBA authority.

  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group.
SAP Sybase IQ 16.0

View any spatial unit of measure property page – None required.

Modify a spatial unit of measure comment – Requires one of:
  • COMMENT ANY OBJECT system privilege.
  • CREATE ANY OBJECT system privilege.
  • ALTER ANY OBJECT system privilege.
  • MANAGE ANY SPATIAL OBJECT system privilege.
Modify any other spatial unit of measure property – Requires one of:
  • MANAGE ANY SPATIAL OBJECT system privilege.
  • ALTER ANY OBJECT system privilege.
Parent topic: Configuring SAP Sybase IQ for Administration
Related tasks
Adding a System Privilege to a Role-Based User
Adding a System Privilege to a User-Extended Role
Adding a System Privilege to a Standalone Role
Adding a System Privilege to a System Role
Adding an Authority to an Authority-Based User
Adding an Authority to a Group