Home » RDBMS Server » Security » Import Fails with error missing or invalid privilege (Oracle 10g)
icon1.gif  Import Fails with error missing or invalid privilege [message #336930] Tue, 29 July 2008 07:03 Go to next message
mameenuddin
Messages: 5
Registered: March 2008
Location: Saudi Arabia
Junior Member

Gentlemen,

We received from our customer database on Oracle 10g, when I import database,the import fails with following error:

IMP-00017: following statement failed with ORACLE error 990:
"GRANT MERGE ON "T_HIERARCHYLEVELS" TO "NGPPLANT""
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege

I have searched on web how to grant MERGE permission but I could not find any workarounds. Can anybody suggest what permission must be granted for this

Thanks in advance for any inputs.
Re: Import Fails with error missing or invalid privilege [message #336962 is a reply to message #336930] Tue, 29 July 2008 08:13 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
"GRANT MERGE ON "T_HIERARCHYLEVELS" TO "NGPPLANT""

There is nothing like this? What is our requirement?

To use merely MERGE statement you need only SELECT and UPDATE privilege on the target table and the SELECT privilege on the source table.

There is one merge permission granted to improve query performance.

SQL> grant merge any view to arju;

Grant succeeded.
Re: Import Fails with error missing or invalid privilege [message #336998 is a reply to message #336962] Tue, 29 July 2008 10:40 Go to previous messageGo to next message
mameenuddin
Messages: 5
Registered: March 2008
Location: Saudi Arabia
Junior Member

thanks for the information provided. I will check back with the customer.

Thanks once more
Re: Import Fails with error missing or invalid privilege [message #337624 is a reply to message #336998] Thu, 31 July 2008 07:51 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
mameenuddin where you are importing in which schema? do that schema own T_HIERARCHYLEVELS. Shocked , if it owns than only below statement will not give error.

GRANT MERGE ON "T_HIERARCHYLEVELS" TO "NGPPLANT

Previous Topic: dbms_fga and join syntax
Next Topic: How to identify source of password changes
Goto Forum:
  


Current Time: Fri Dec 09 02:21:13 CST 2016

Total time taken to generate the page: 0.13952 seconds