Event Privilege Summary

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

Creating an Event

Database Version Event Privileges
SAP Sybase IQ 15.3 and 15.4 You must have DBA authority.
SAP Sybase IQ 16.0 You must have one of:
  • MANAGE ANY EVENT system privilege
  • CREATE ANY OBJECT system privilege

Deleting an Event

Database Version Event Privileges
SAP Sybase IQ 15.3 and 15.4 You must have DBA authority.
SAP Sybase IQ 16.0 You must have one of:
  • MANAGE ANY EVENT system privilege
  • DROP ANY OBJECT system privilege

Disabling or Enabling an Event

Database Version Event Privileges
SAP Sybase IQ 15.3 and 15.4 You must have DBA authority.
SAP Sybase IQ 16.0 You must have one of:
  • MANAGE ANY EVENT system privilege
  • ALTER ANY OBJECT system privilege

Triggering an Event

Database Version Event Privileges
SAP Sybase IQ 15.3 and 15.4 You must have DBA authority.
SAP Sybase IQ 16.0 You must have the MANAGE ANY EVENT system privilege.

Generating Event DDL Commands

Database Version Event Privileges
SAP Sybase IQ 15.3 and 15.4 None.
SAP Sybase IQ 16.0 None.

Viewing or Modifying Event Properties

Database Version Event Privileges
SAP Sybase IQ 15.3 and 15.4

View event properties – none.

Modify event comment or properties – you must have DBA authority.
SAP Sybase IQ 16.0 View event properties only – none.
Modify event properties – you must have one of:
  • MANAGE ANY EVENT system privilege
  • ALTER ANY OBJECT system privilege
Modify event comment only – you must have one of:
  • MANAGE ANY EVENT system privilege
  • CREATE ANY OBJECT system privilege
  • ALTER ANY OBJECT system privilege
  • COMMENT ANY OBJECT system privilege

Creating an Event Schedule

Database Version Event Schedule Privileges
SAP Sybase IQ 15.3 and 15.4 You must have DBA authority.
SAP Sybase IQ 16.0 You must have one of:
  • MANAGE ANY EVENT system privilege
  • ALTER ANY OBJECT system privilege

Deleting an Event Schedule

Database Version Event Schedule Privileges
SAP Sybase IQ 15.3 and 15.4 You must have DBA authority.
SAP Sybase IQ 16.0 You must have one of:
  • MANAGE ANY EVENT system privilege
  • ALTER ANY OBJECT system privilege

Generating Event Schedule DDL Commands

Database Version Event Schedule Privileges
SAP Sybase IQ 15.3 and 15.4 None.
SAP Sybase IQ 16.0 None.

Viewing or Modifying Event Schedule

Properties
Database Version Event Schedule Privileges
SAP Sybase IQ 15.3 and 15.4

View any event schedule property page – none.

Modify any event schedule property – you must have DBA authority.
SAP Sybase IQ 16.0

View any event schedule property page – none.

Modify any event schedule property – you must have one of:
  • MANAGE ANY EVENT system privilege
  • ALTER ANY OBJECT system privilege
Parent topic: SAP Sybase IQ Authority and Privilege Reference
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