duplicate tables & grants

From: <_at_nnib>
Date: Wed, 12 Sep 2001 00:38:36 +0200
Message-ID: <9nm3or$8vv$1@antares.worldonline.fr>

hi,

I've got 3 users SU, SU1 and SU2

SU own 100 tables
SU1 own 100 tables with the same names
SU2 has grant on all the SU and SU1 tables.

I need to refresh the SU1 tables with the content of SU (before an Euro migration)

I think to :

1 / drop all the SU1 tables
2 / exp the SU tables
3 / imp fromuser=SU touser=SU1

but what's about the grants ???
I think SU2 couldn't access to SU1 tables after...('cause of the drop)

How can I do if i don't want to recreate all grants ?

Thanx
@nnib
Revolted by the human violence Received on Tue Sep 11 2001 - 17:38:36 CDT