Table Trigger Privilege Summary

A list of the system privileges and object permissions required to complete the various table trigger tasks on database objects.

Creating a Table Trigger

Database Version	Table Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. RESOURCE authority, along with one of: ALTER permission on the underlying table of the trigger. You own the underlying table of the trigger.
SAP Sybase IQ 16.0	Requires one of: CREATE ANY TRIGGER system privilege. CREATE ANY OBJECT system privilege. Also requires one of: ALTER ANY OBJECT system privilege. ALTER ANY TABLE system privilege. ALTER permission on the underlying table of the trigger. You own the underlying table of the trigger.

Database Version	Table Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. RESOURCE authority, along with one of: ALTER permission on the underlying table of the trigger. You own the underlying table of the trigger.
SAP Sybase IQ 16.0	Requires one of: ALTER ANY OBJECT system privilege. ALTER ANY TABLE system privilege. You own the underlying table of the trigger.

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

Database Version	Table Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	View any trigger property page – None required. Modify any trigger property – Requires one of: DBA authority. RESOURCE authority, along with one of: ALTER permission on the underlying table of the trigger. You own the underlying table of the trigger.
SAP Sybase IQ 16.0	View any trigger property page – None required. Modify a trigger comment – Requires one of: CREATE ANY TRIGGER system privilege ALTER ANY TRIGGER system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege COMMENT ANY OBJECT system privilege Note: ALTER permission on the table is not required to modify a comment. Modify any other trigger property: Requires one of: ALTER ANY OBJECT system privilege. ALTER ANY TRIGGER system privilege, along with one of: ALTER ANY TABLE system privilege. You own the underlying table of the trigger.

Database Version

Table Trigger Privileges

SAP Sybase IQ 15.3 and 15.4

View any trigger property page – None required.

Modify any trigger property – Requires one of:

DBA authority.
RESOURCE authority, along with one of:
- ALTER permission on the underlying table of the trigger.
- You own the underlying table of the trigger.

SAP Sybase IQ 16.0

View any trigger property page – None required.

Modify a trigger comment – Requires one of:

Note: ALTER permission on the table is not required to modify a comment.

Modify any other trigger property:

Requires one of:
- ALTER ANY OBJECT system privilege.
- ALTER ANY TRIGGER system privilege, along with one of:
  - ALTER ANY TABLE system privilege.
  - You own the underlying table of the trigger.