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