cancel
Showing results for 
Search instead for 
Did you mean: 

Search Catalog Objects For Export not getting updated

former_member215470
Participant
0 Kudos

Dear Gurus,

While searching for Catalog Objects for Export in SAP HANA DB, the search results are not getting populated in the Matching Items Box, though the corresponding tables/objects do exist there. This is shown below -

Could anyone please let me know the authorizations needed to be provided on the ID, so that this can be resolved?

Many thanks in advance,
Sayan Dey

View Entire Topic
zsolt_zoldi
Advisor
Advisor

Dear Sayan,

Please check if the database user has the following privileges:
- SELECT privilege for the catalog objects that you want to export
- EXPORT system privilege

For more information please refer to the following documents:
Export Tables and Other Catalog Objects
EXPORT Statement (Data Import Export)
2008835 - Export catalog objects fails with 'insufficient privileges'

Best Regards,
Zsolt

former_member215470
Participant

Hi Zsolt,

Thanks for your guidance. I will check and come back to you.

I will refer the links as well.

Many thanks again,
Sayan Dey

former_member215470
Participant
0 Kudos

Hi Zsolt,

Thanks to you again!

We checked the user ID in which we are getting the issue and found that it was due to the lower version of the HANA Studio.

It is working fine from HANA Studio of a higher version.

Thanks,
Sayan Dey

zsolt_zoldi
Advisor
Advisor
0 Kudos

Hello Sayan,

I'm glad to hear that using a higher HANA Studio version solved the issue.
Have a nice day.

Best regards,
Zsolt