Subject | Re: [firebird-support] Changing Owner of Table |
---|---|
Author | Thomas Steinmaurer |
Post date | 2007-12-22T11:19:42Z |
Hi Todd,
Check out my session from the Firebird Conference 2006:
http://www.ibphoenix.com/downloads/FirebirdConf2006/TECH-R01103-S/TECH-R01103-S.zip
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
> Thanks for the reply ....SQL Privileges, ...
>
> 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?
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 updateAlways? BAD THING!
> the System Tables directly.
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