Re: Full Import Privileges Problems

Hi Chris
The correct sequence of scripts after creation is catalog.sql
catproc.sql
catexp.sql
The standard package is included in catproc.sql. Given the fact that export and import both seem to use pl/sql (which is in catproc.sql), you probably have a crippled import run. To show whether the grants are in the dump use imp with either show=y full=y logfile=<file> or indexfile=<filename>
Normally, imp issues more or less hidden become user commands (you can't issue this command in sqlplus) and that makes sure everything works. If that still doesn't help refer to a post of Thomas Kyte (tkyte_at_us.oracle.com) where he demonstrates how you can grant on behalf of another user. If you can't find it, I will post his script tomorrow.

Hth,

Sybrand Bakker, Oracle DBA

Chris Ermlich wrote in message <929643634.538.76_at_news.remarQ.com>...
>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 ?
>
>PS.: 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 - 15:33:41 CDT