Subject | Changing Table Owner |
---|---|
Author | Artur Anjos |
Post date | 2003-08-23T17:40:30Z |
Hi All,
I need to change the Table owner in all database tables.
Can someone point me out how I can do this? I know that the change should be
somewere at RDB$USER_PRIVILEGES, but I'm a little afraid that this will not
be enough.
Can someone tell correct way to do it? I will need to disable some system
triggers to do it, and I'm a little afraid that the triggers could be there
not onling to prevent the change....
"By-The-Book" alternative option is create a backup metadata only, create a
new database from it, and pump the data back. No funny work. :-)
Any more options available?
Artur
I need to change the Table owner in all database tables.
Can someone point me out how I can do this? I know that the change should be
somewere at RDB$USER_PRIVILEGES, but I'm a little afraid that this will not
be enough.
Can someone tell correct way to do it? I will need to disable some system
triggers to do it, and I'm a little afraid that the triggers could be there
not onling to prevent the change....
"By-The-Book" alternative option is create a backup metadata only, create a
new database from it, and pump the data back. No funny work. :-)
Any more options available?
Artur