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 Requires DBA authority.
SAP Sybase IQ 16.0 Requires 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 Requires DBA authority.
SAP Sybase IQ 16.0 Requires 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 Requires DBA authority.
SAP Sybase IQ 16.0 Requires 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 Requires DBA authority.
SAP Sybase IQ 16.0 Requires MANAGE ANY EVENT system privilege.

Generating Event DDL Commands

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

Viewing or Modifying Event Properties

Database Version Event Privileges
SAP Sybase IQ 15.3 and 15.4

View event properties – None required.

Modify event comment or properties – Requires DBA authority.

SAP Sybase IQ 16.0 View event properties only – None required.
Modify event properties – Requires one of:
  • MANAGE ANY EVENT system privilege.
  • ALTER ANY OBJECT system privilege.
Modify event comment only – Requires 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 Requires DBA authority.
SAP Sybase IQ 16.0 Requires 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 Requires DBA authority.
SAP Sybase IQ 16.0 Requires 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 required.
SAP Sybase IQ 16.0 None required.

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 required.

Modify any event schedule property – Requires DBA authority.

SAP Sybase IQ 16.0

View any event schedule property page – None required.

Modify any event schedule property – Requires one of:
  • MANAGE ANY EVENT system privilege.
  • ALTER ANY OBJECT system privilege.
Related concepts
Event Schedules
Related tasks
Creating an Event
Deleting an Event
Disabling an Event
Enabling an Event
Triggering an Event
Generating Event DDL Commands
Viewing or Modifying Event Properties