Problem: Users other than the owner of the database need to be able to alter triggers. Privileges for triggers are not affected by the grant/revoke statements, and only the SYSDBA and the owner of the database can alter triggers. Solution: The information in this article applies to: * InterBase 5.x The way to change the owner of the database is to do a backup and restore as the user who needs to have privileges for altering triggers. This has obvious limitations in that still only one user at a time will be able to have these privileges, and it may not be convenient to have to go through this process, when the need to alter a trigger exists. In InterBase v5.0 SQL Roles are implemented according to the ANSI SQL 3 syntax. This feature can allow the users logging-on under a specific role to feasibly gain the necessary access rights to the table and its associated triggers.
Last Modified: 18-OCT-00