OraFAQ Forum: Security » Import Fails with error missing or invalid privilege

Home » RDBMS Server » Security » Import Fails with error missing or invalid privilege (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import Fails with error missing or invalid privilege [message #336930]

Tue, 29 July 2008 07:03

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.

Report message to a moderator

Re: Import Fails with error missing or invalid privilege [message #336962 is a reply to message #336930]

Tue, 29 July 2008 08:13

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.

Report message to a moderator

Re: Import Fails with error missing or invalid privilege [message #336998 is a reply to message #336962]

Tue, 29 July 2008 10:40

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

Report message to a moderator

Re: Import Fails with error missing or invalid privilege [message #337624 is a reply to message #336998]

Thu, 31 July 2008 07:51

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 07:56:49 CST 2025