cancel
Showing results for 
Search instead for 
Did you mean: 

trying to import a table but getting this:

Former Member
0 Kudos

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

i have selected Tables/Import

Accepted Solutions (1)

Accepted Solutions (1)

tomas-krojzl
Active Contributor
0 Kudos

Hello,

this is security related problem.

Please see my blog for required privileges (chapter 2.1 Required security authorizations):

I think you are missing IMPORT privilege (but can be other privilege as well).

2.1.3 Target: Import of data content

For table import you need to have IMPORT system privilege and write access to target schema:

for table creation (and optionally data load): CREATE ANY

for table dropping and re-creation (and optionally data load): CREATE ANY, DROP

Note: It might look like error but you do not need any other privileges (no need to grant SELECT, INSERT or DELETE privilege).

In case that target schema does not exist and you wish to create is as part of import process you need to grant the user system privileges IMPORT and CREATE SCHEMA (no other privileges are required).

Note: From owner perspective it does not matter who started the import. Object owner is always user SYSTEM.

Tomas

Former Member
0 Kudos

Hi Tomas,

thank you for going such a great work in the forums, but i keep finding inconsistencies in the documentation, for example when trying to execute this SQL statement:

create schema <schema name>.

i get this error:

SAP DBTech JDBC: [257] (at 15): sql syntax error: incorrect syntax near ".": line 1 col 15 (at pos 15).

should i or should i not use "."? i'm trying to do it both under my id and under SYSTEM id. Neither is successful.

rgds,

greg

Former Member
0 Kudos

Hi Greg,

Do not use the '.' in the syntax. The below syntax should be fine.

create schema <schema name>

Regards, Rahul

tomas-krojzl
Active Contributor
0 Kudos

Hello,

there definitely should not be "." at the end of statement - not sure where exactly it was written like this...

Is it possible that dot character was just placed as normal end of sentence?

Tomas

former_member182779
Active Contributor
0 Kudos

"." at the end of the line? Isn't that too much ABAP related? -;) Remember that SQL uses ";" as the end of the line delimiter...but it's hard to get rid of the bad habits...still have the problem when I need to SORT an internal table in ABAP...I usually put ORDER like in other programming languages -:P

Greetings,

Blag.

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

you can change default statements separator, but I'm not sure it can be set to '.'

Answers (2)

Answers (2)

Former Member
0 Kudos

HI.

When you create SLT Connection (LTR Transaction), the system create SCHEMA in HANA, with the configuration name wich is indicated in General data.

Hana create SCHEMA and ROLE DATA_PROV, POWER_USER, SELECT_USE and USER_ADMIN, please add this ROLE into USER (SYSTEM), wich is used to connect ECC with HANA.

Remember the USER (SYSTEM) used to import  all tables into your SCHEMA , need the ROLE and IMPORT privileges.

Best Regards.

Former Member
0 Kudos

Hi,

Can you send more information, like HANA version?

Error log

thanks

Rao