duplicate tables & grants

1. don't drop the tables of SU1 but truncate them
2. exp SU tables
3. imp fromuser=SU touser=SU1 ignore=Y

ignore=Y means to ignore errors because the tables are in scheme from SU1 and cannot be created

Gerd Kock

-----Ursprüngliche Nachricht-----
Von: @nnib [mailto:annibale_at_ifrance.com] Bereitgestellt: Mittwoch, 12. September 2001 00:39 Bereitgestellt in: server
Unterhaltung: duplicate tables & grants
Betreff: duplicate tables & grants

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 Wed Sep 12 2001 - 02:09:45 CDT