Re: Full Import Privileges Problem

I don't honestly know, but I'm thinking the privileges may get overlayed at the beginning of the import? Try querying system's privileges after the import and see if they've changed.
I would try the import as sys rather than system, that might take care of it.. If your doing
a DB from scratch, I don't think importing as sys will cause any harm..

• Dc.

Chris Ermlich wrote:

> 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 Fri Jun 18 1999 - 11:14:55 CDT