Re: missing privileges on tables after full import DB

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Thu, 07 Feb 2002 12:25:37 +0400
Message-ID: <rde46u8mams00tusehrkb60rjiof6tqt34@4ax.com>

On 6 Feb 2002 23:15:48 -0800, nguyen.hieu_at_citicorp.com (hieu) wrote:

>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

Did u do the exports with the grants = Y [ which is the default] and the grants =Y in Imports...

Maybethere lies the error...

[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Thu Feb 07 2002 - 02:25:37 CST