View Trigger Privilege Summary

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

Creating a View Trigger

Database Version	View Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority RESOURCE authority and you own the underlying view 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 VIEW system privilege You own the underlying view of the trigger

Database Version	View Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the underlying view of the trigger
SAP Sybase IQ 16.0	You must have one of: ALTER ANY OBJECT system privilege ALTER ANY VIEW system privilege You own the underlying view of the trigger This gives you ALTER permission on the underlying view of the trigger.

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

Database Version	View Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	View trigger properties only – none. Modify trigger comment or properties – you must have one of: DBA authority RESOURCE authority and you own the underlying view 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 view is not required to modify a comment. Modify any other trigger property – you must have one of: ALTER ANY OBJECT system privilege ALTER ANY TRIGGER system privilege, along with one of: ALTER ANY VIEW system privilege You own the underlying view of the trigger

Database Version

View Trigger Privileges

SAP Sybase IQ 15.3 and 15.4

View trigger properties only – none.

Modify trigger comment or properties – you must have one of:

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 view is not required to modify a comment.

Modify any other trigger property – you must have one of:

ALTER ANY OBJECT system privilege
ALTER ANY TRIGGER system privilege, along with one of:
- ALTER ANY VIEW system privilege
- You own the underlying view of the trigger