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	Requires one of: DBA authority. RESOURCE authority and you own the underlying view 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 VIEW system privilege. You own the underlying view of the trigger.

Database Version	View Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. You own the underlying view of the trigger.
SAP Sybase IQ 16.0	Requires ALTER permission on the underlying view of the trigger by virtue of any 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	None required.
SAP Sybase IQ 16.0	None required.

Database Version	View Trigger Privileges
SAP Sybase IQ 15.3 and 15.4	View trigger properties only – None required. Modify trigger comment or properties – Requires 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 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 view 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 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 required.

Modify trigger comment or properties – Requires one of:

SAP Sybase IQ 16.0

View any trigger property page – None required.

Modify a trigger comment – Requires one of:

Note: ALTER permission on the view 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 VIEW system privilege.
  - You own the underlying view of the trigger.