Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> missing privileges on tables after full import DB
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