Skip to Content
-1

No access to view data in SAP_HANA_DEMO tables in hana trial system

Jan 09 at 06:45 AM

57

avatar image

Hi All,

I am using hana trial system, in that i am trying to check the data in tables(SAP_HANA_DEMO).....but its giving error message like "insufficient previliges..........".

there is anyway to check the data in those tables and use them in our own to be created procedures.

we dont have much tables to create any procedure and function etc......

below is the screenshot for more details.................

please suggest on it

Thanks

DB

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Jan 09 at 06:01 PM
0

Please do a search before you post. Similar authorization issues were discussed and answered several times here.

Your user need select privileges on the object you wanna select from.

Regards,
Florian

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Hi Florian,

thanks for you response, if already posted/answered this type of questions for trial access,please provide link.at present my trial user is SYSTEM only.

0

So if you are using the SYSTEM user, did you check that the user has the select privileges e.g. on the table for on the schema?

0

Hi Florian,

by default, SYSTEM user got below roles........... have you any more idea to solve the problem.

hana-demo2.png (21.0 kB)
0

Are you reading what I write and are you able to check if the user has the select privileges for table or the schema??? If not then I would recommend to have a look into the official documentation to be able to solve such little issues by yourself.

I think that the user does not have the required object privileges directly assigned or via a role.

0