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 -> missing privileges on tables after full import DB

missing privileges on tables after full import DB

From: hieu <nguyen.hieu_at_citicorp.com>
Date: 6 Feb 2002 23:15:48 -0800
Message-ID: <b060bd9f.0202062315.1d74c08a@posting.google.com>


Hi,
I have found this very common with 8i which would causes user's functions, procedures, packages or views invalid after import. Let say user A granted SELECT on table EMP to user B, but the SELECT privilege on A.EMP will not be granted to B during full DB import. So every time I have to check in old DB then make a script to re-run again in new DB then recompile invlid objects. Is there a way to fix this ?

Thanks
Hieu Received on Thu Feb 07 2002 - 01:15:48 CST

Original text of this message

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