on 10-11-2017 11:44 AM
Hello
I create SQL Script calculation view. In this view i used PAL method CROSTON
If i activated view I got an error:
Short Text
Insufficient privileges - not authorized
Cause
User is not authorized to deploy attribute view
Recommendations
Grant SELECT privileges on schemas of the used data foundation tables to user "_SYS_REPO"
I executed :
GRANT SELECT ON SCHEMA USER1 TO _SYS_REPO WITH GRANT OPTION
And give my user roles:
But error was saved.
If i executed method CALL "USER1"."CROSTON_TEST_PROC"() in SQL console then everything was fine, i got data.
View code:
/********* Begin Procedure Script ************/
BEGIN
in_data2 = select * FROM "USER1"."PAL_CROSTON_DATA_TBL";
in_parameter2 = select * FROM "USER1"."PAL_CONTROL_TBL3";
CALL "USER1"."CROSTON_TEST_PROC"(:in_data2, :in_parameter2, result2, PAL_CROSTON_STATISTICS_TBL);
var_out = SELECT TIME, OUTPUT FROM :result2;
END /********* End Procedure Script ************/
I get an error
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.