Re: missing privileges on tables after full import DB

Ganesh Raja <ganesh_at_gtfs-gulf.com> wrote in message news:<rde46u8mams00tusehrkb60rjiof6tqt34_at_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

We usually make two exports, the second of which is made with the rows=n option so that no data is exported. Then after running a regular full import we run the second import and it brings anything lost in the first export.

The import utility also has a rows=n option. Try using it to bring in any lost objects/grants. I believe you will still want the ignore=y option. Please review the option in the Utility manual before using.

• Mark D Powell --