Skip to Content
author's profile photo Former Member
Former Member

SAP HANA Cloud Trial - insufficient privilege

Dear community,

I use the HANA Tools for Eclipse and a free Trial HANA Instance on SAP HANA Cloud Platform.

However I have some Problems with the Application Function Library. I can set the Schema to _SYS_AFL but can't drop, create there some view or table.


My code looks like following:

SET SCHEMA _SYS_AFL;

DROP TYPE PAL_DATA_T;
CREATE TYPE PAL_DATA_T AS TABLE(
"CLIENTID" INT,
"ITEM" VARCHAR(100)
);

and I get following Errors:

Statement 'SET SCHEMA _SYS_AFL' 
successfully executed in 12 ms 464 µs  (server processing time: 0 ms 212 µs) - Rows Affected: 0 
Could not execute 'DROP TYPE PAL_DATA_T'
SAP DBTech JDBC: [395]: invalid user-defined type name: PAL_DATA_T: line 1 col 11 (at pos 10)
Could not execute 'CREATE TYPE PAL_DATA_T AS TABLE( "CLIENTID" INT, "ITEM" VARCHAR(100) )'
SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Any help appreciated!

Regards Matthias

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 20, 2015 at 12:34 PM

    Hi,

    have you found a solution?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.