Skip to Content
avatar image
Former Member

i am trying to create calculation view by using sql script but i am facing in sufficient privilige

i am trying to create calculation view by using sql script but i am facing in sufficient privilige:not authorized set schema DDL statement.

I tried "GRANT SELECT ON SCHEMA MY_PROJECT TO _SYS_REPO WITH GRANT OPTION" though i facing the error.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • I think you will need to provide more details on what you are trying to do. What exactly are you coding in your SQLScript to create the Calculation View? What APIs are you calling? What exactly is the privilege error you are receiving?

  • Former Member

    THANKS FOR YOUR RESPONSE THOMAS

    HERE IS MY SCRIPT

    THIS IS MY PROCEDURE

    ---------------------------------

    CREATE PROCEDURE "MY_PROJECT"."PROC_CAL"(IN CUSTNUMBER NVARCHAR(25),OUT VAR1 "TYPE_TABLE") LANGUAGE SQLSCRIPT SQL SECURITY INVOKER

    READS SQL DATA AS

    BEGIN

    VAR1=SELECT CNAME,PHONE FROM "MY_PROJECT"."CUSTOMERS" WHERE CUSTOMERNUMBER=:CUSTNUMBER; END;

    TABLE TYPE

    ---------------

    CREATE TYPE "MY_PROJECT"."TYPE_TABLE" AS TABLE ("CNAME" NVARCHAR(25),"PHONE" NVARCHAR(20))

    I AM CALLING IN MY CALCULATION VIEW LIKE THIS

    ------------------------------------------

    BEGIN

    CALL "MY_PROJECT"."PROC_CAL"('V_TAB',A);

    VAR_OUT=SELECT CNAME,PHONE,1 AS CNT FROM :A;

    END

    I am facing not n sufficient privilige:not authorized set schema DML/DDL statement.

  • Get RSS Feed

1 Answer

  • May 23 at 09:18 PM

    Hi,

    If your view is not assigned to an analytic privilege, make sure you make the AP setting blank in your view semantic layer.

    Shyam

    Add comment
    10|10000 characters needed characters exceeded