Error: “You are not allowed to generate events for table <yourSQLView>“ (4321444)

Error: “You are not allowed to generate events for table “

A SQL View is created using the Schema Extension tool.  The permission group CCCEditPermissions has full rights on this SQL View.  After saving the view and compiling the database Object Browser is launched, and from the Navigation view the newly created View is selected and one object opened.  The follow error message is received when generating an action:

“You are not allowed to generate events for table <yourSQLView>“

As per definition (for security reasons) a user needs to have change permissions on a table to be able to fire an event.  Objects of a view are read-only.

To avoid this a program function can be defined in Designer (DialogFeature, which is available since version 7.1.1) and the event assigned to the feature.

All users who have that feature (via a permissions group) will be allowed to fire the event, although it is a view.

1. In Designer go to Permissions | Program functions

2. Create a new Program function and assign the appropriate permissions group.

3. Assign the appropriate object event.