Re: Changeing ownership of a database, and related tables
On Thu, 5 Jan 1995 05:26:36 GMT,
Tony Peterman <automata@netcom.com> wrote:
>I have several databases that I need to change the database ownership, and
>related tables on. What is the easiest way to do this. I takes about 8 hours
>to unload, and reload ll the tables in a single database, so that is not the
>preferable option.
>
>Thanks,
>
>Tony
Tony,
I've found that the best way out of that trap is to never get in in the
first place. Create your tables as the informix super user and grant the
primary user ALL WITH GRANT OPTION. So when users leave, they don't leave a
gaping hole in your security and you still have positive control.
Since this option does not seem to be open to you, I'm afraid you'll just
have to bite the bullet and do the dirty 8 hour deed. There are a variety
of options open to you. I would unload, build new and reload if the disk
space was open. If not, look into dbexport/dbimport. One thing that you do
NOT want to do is a load WITH indexes!!! This would make an 8 hour job
into a 10 or 15 hour job pretty quick.
-James
============================================================================
_______
/ |
James R. Ware / |
/ | jware@server.cdpa.ms.gov
MS Dept. of Archives | |
Systems Administrator \\ |
100 S. State St. | | PHONE: (601) 359-6888
P.O. Box 571 / | FAX: (601) 359-6905
Jackson, MS 39205-0571 / |
|______ |
/ |
\\____|
============================================================================