community.borland.com

Article #25349: Changing Owner of Database

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