Skip to Content

Can not assign Privileges for procedures in HANA trial

Hi,

I am using the HANA trial version. In an xsjs file a procedure is called like

var cst = conn.prepareCall( "call mC_get" );

The procedure is located under my NEO-xx schema in procedures and reads from a table of that schema.

The table select priviliges have been assigned and native select statements work from xsjs .

The call procedure statement however throws an error like

"Error while executing query: [dberror(Connection.prepareCall): 258 - insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:2182"

I was trying all kind of sql grant statemants to grant some select privileges but did not succeed (mostly the grant statemebnt throwed another insufficient privilege error)

What do I need to do to allow the xsjs app process my stored procedures ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2013 at 09:36 PM

    Hello,

    I have the same issue. The name of my procedure is s0009333833trial.myhana.useraudit.db/getuserdistribution

    I tried to add the following line in an hdbrole file :

    sql object s0009333833trial.myhana.useraudit.db/getuserdistribution: EXECUTE;

    but I get the following error when activating the role :

    ERROR s0009333833trial/myhana/useraudit/model_access.hdbrole
    Repository: CheckObjects failed for at least one object;activationID 54012: Error during processing of object {tenant: , package: s0009333833trial.myhana.useraudit, name: model_access, suffix: hdbrole}: Syntax error: Unexpected '/' (Line: $line$, Col: $column$)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2014 at 09:58 AM

    I found a solution for this problem for those who are still interested.

    Assign a role to your user in which the following statement is included:

    sql object <package>::<procedure>: EXECUTE;

    Kind regards.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Martin Boudikianov

      Hi Martin,

      I didn't mention before but in the same role I also included this statement to ensure I can access my schema:

      catalog schema <schema_name> : SELECT, INSERT, UPDATE, DELETE, DROP;

      Maybe this has nothing to do with it but it's the only thing I can think of that is different in our situations.

      Kind regards.

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.