Subject Re: [firebird-support] Changing Owner of Table
Author Thomas Steinmaurer
Hi Todd,

> Thanks for the reply ....
>
> I have no problem using your tool, but I would also like to know what is
> 'a bit more involved'.
>
> When I look through the System Tables I see the field Owner_Name in
> RDB$RELATIONS, RDB$PROCEDURES and RDB$ROLES.
>
> Are the other two tables the 'bit more involved' or is there something else?

SQL Privileges, ...

Check out my session from the Firebird Conference 2006:
http://www.ibphoenix.com/downloads/FirebirdConf2006/TECH-R01103-S/TECH-R01103-S.zip

> I have this one developer that works with me that always wants to update
> the System Tables directly.

Always? BAD THING!

Seriously. You can open a can of worms when updating the system tables
without knowing exactly what you are doing.



--
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