cancel
Showing results for 
Search instead for 
Did you mean: 

Error while creating virtual table in Hana

Former Member
0 Kudos

Hi Folks,

Good Day!

I am trying to create the virtual table in Hana system from Hadoop data base but am getting some privilege issue.

Please help me to resolve the issue.

Error Screen shot:

Thanks,

Hari

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Hari,

Check if you have the following privileges assigned to your user ID in Object privileges for the created Remote DNS

Regards,

Nehal

Former Member
0 Kudos

Hi Nehal,

I did not find the said role against my user id.

Thanks,

Hari

Former Member
0 Kudos

Hi Hari,

You have to click the add ( + ) button. Then search for your Hadoop DNS name that was configured earlier, and then check its privileges. Remember you might need a SYSTEM ID to enable this too or you might get an insufficient privileges error while trying.

Nehal.

Former Member
0 Kudos

Hi Nehal,

I could not find the role by name Hadoop DNS .

Thanks,

Hari

Former Member
0 Kudos

Thanks Nehal, Its worked for me........

Former Member
0 Kudos

Hi Nehal,

do you know the syntax for the repo role aswell?

Best regards, Christoph

Former Member
0 Kudos

Didnt understand your question Christoph

Former Member
0 Kudos

Hi Nehal,

I granted CREATE VIRTUAL TABLE and DROP to SYS_REPO user, to be able to enhance my repository role. Unfortunatly I´m not able to do so, because the sythax compared to other sql objects is different.

Regards, Christoph.

Former Member
0 Kudos

Still not sure if I fully understand, but if you want to grant it to _SYS_REPO, can you not do it from the User drop down just like you do it for other users? (Like mentioned above). _SYS_REPO is also a user in that right.

Otherwise. Lookup the link below. It provides the syntax for CREATE VIRTUAL TABLE. But what the place holders are you will have to figure out. One way is to execute it for another user from the admin screen and check the command in the index log.

CREATE TABLE - SAP HANA SQL and System Views Reference - SAP Library

Former Member
0 Kudos

Hi Nehal,

my problem is, that I cannot implement this logic into my repo role.

There is no document that describes the correct syntax. Please find a screenshot attached.

Regards, Christoph.

Former Member
0 Kudos

Hmm,

Thts a tough one. You will have to check with SAP via a ticket. Doubt CREATE VIRTUAL TABLE is supported yet in a repo role

Nehal.

Former Member
0 Kudos

Ok, thanks Nehal!

draschke
Active Contributor
0 Kudos

Hi Christoph,

"my problem is, that I cannot implement this logic into my repo role.

There is no document that describes the correct syntax."

Did you find a solution for this problem? Do you know the right syntax? Is this possible?

BR,

Dirk

Former Member
0 Kudos

Hi Dirk,

unfortunately not!

As a workaround, I´m using a technical user, that is also owner of every remote data source to implement virtual tables.

BR, Christoph.

draschke
Active Contributor
0 Kudos

Hi Christoph,

thanks, than I need to go the same way as you.

Fought I could transport a repository object in our productive system.

BR,

Dirk

Answers (0)