Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: duplicate tables & grants

Re: duplicate tables & grants

From: Matthias Gresz <nospam_at_newsranger.com>
Date: Wed, 12 Sep 2001 10:36:12 GMT
Message-ID: <wUGn7.5083$%u4.26900@www.newsranger.com> 





If the tables of u and u1 haven't the identical structure you can't go Anatoly's
way. To refresh the grants :



spool somewhere


Select


'Grant XXX on ' || table_name || ' to U2;'
from	


user_tables;


@somewhere





Hth



Matthias
Received on Wed Sep 12 2001 - 05:36:12 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US