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	You must have 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	You must have one of: CREATE ANY TRIGGER system privilege CREATE ANY OBJECT system privilege You must also have 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	You must have 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	You must have 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.
SAP Sybase IQ 16.0	None.

Database Version	Table Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	View any trigger property page – none. Modify any trigger property – you must have 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. Modify a trigger comment – you must have 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 – Yyu must have 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.

Modify any trigger property – you must have 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.

Modify a trigger comment – you must have one of:

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

Modify any other trigger property – Yyu must have 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