Hi Max,

> With Interbase 6.0, is there an easy way to change the creator of
> tables, triggers etc? We have a database that was created by a user
> that has now left. This database has now been taken over by another
> user, but as he is not the creator of most of its objects, he can not do
> things such as drop tables, alter tables, alter triggers etc. These
> actions can only be performed by the creator, sysdba or users with o/s
> root privileges. Granting the user sysdba or root is not an option, so
> it looks like I must somehow change the object's creator to the new user.
>
> I originally thought I would be able to achieve this by changing the
> database owner with a backup and restore. However, this does not change
> any of the creator information. After much reading around, the only
> possible way that I have found is to manually alter the RDB$OWNER_NAME
> field in RDB$RELATIONS. However, I'm nervous about fiddling with the
> system tables, and this situation isn't ideal anyway as a trigger is in
> place to stop anyone other than the creator from modifying this field
> (preventing sysdba from doing it!).
>
> Can anyone provide an alternate solution, or offer some guidance on
> modifying RDB$RELATIONS in a safe way?

Yes, by using our freely available FBOwnerMigrator tool. Request the
download location by sending an email to me ("t . steinmaurer @
upscene.com")

> Thanks,
>
> Max Spicer
>
> PS Apologies for the cross-post from newsgroups.borland.com!

This isn't treated as X-posting. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com