Full Import Privileges Problem

I am running a FULL IMPORT of an existing *.dmp file into a newly created database instance. All seems to work well, however, most of the object grants fail. E.g.:

"GRANT INSERT ON "TABLE_A" TO "USER_A"" ORA-01031: insufficient privileges

After creating the new instance, I run the following scripts and grants (prior to the full import):
catalog.sql
standard.sql
dbmsstdx.sql
catexp.sql

grant imp_full_database to system with admin option; grant exp_full_database to system with admin option; grant dba to system with admin option;

All scripts and grants above work well without errors.

However, when running a full import as 'system' I can't seem to get the grants back as needed. All other items seem to be re-created just fine (e.g. tables, rollback segments, users, etc.)

What am I missing ?
How can 'system' be enabled to grant privileges to other objects ?

I am running Oracle 7.3.2.2 on HP-UX 10.2 Thanks for the help.
Chris :-)
cermlich_at_swri.edu Received on Thu Jun 17 1999 - 13:01:29 CDT