on 11-16-2011 1:40 AM
SAP DBTech JDBC: [258]: insufficient privilege: Not authorized
i have selected Tables/Import
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
"." 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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you send more information, like HANA version?
Error log
thanks
Rao
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.