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 You must have one of:
  • DBA authority
  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group
SAP Sybase IQ 16.0 You must have 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 You must have one of:
  • DBA authority
  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group
SAP Sybase IQ 16.0 You must have 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.
SAP Sybase IQ 16.0 None.

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.

Modify spatial reference system properties or comments – you must have 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.

Modify spatial reference system properties – you must have one of:
  • MANAGE ANY SPATIAL OBJECT system privilege
  • ALTER ANY OBJECT system privilege
Modify spatial reference system comment – you must have 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 You must have one of:
  • DBA authority
  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group
SAP Sybase IQ 16.0 You must have one of:
  • CREATE ANY OBJECT system privilege
  • MANAGE ANY SPATIAL OBJECT system privilege

Deleting a Spatial Unit of Measure

Database Version Spatial Unit of Measure Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group
SAP Sybase IQ 16.0 You must have 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.
SAP Sybase IQ 16.0 None.

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.

Modify spatial unit of measure properties or comments – you must have 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.

Modify a spatial unit of measure comment – you must have 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 – you must have one of:
  • MANAGE ANY SPATIAL OBJECT system privilege
  • ALTER ANY OBJECT system privilege
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