on 09-19-2018 4:44 PM
Hello,
I've created table type in HANAADMIN Schema using this
create type "HANAADMIN"."IT_VBAK" AS TABLE(
VBELN NVARCHAR(10),
NETWR DECIMAL(15,2)
)
Then Created procedure on same schema
PROCEDURE "HANAADMIN"."Financial::SALESORDER" (
OUT TVBAK IT_VBAK
)
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
--DEFAULT SCHEMA <default_schema_name>
READS SQL DATA AS
BEGIN
/*****************************
Write your procedure logic
*****************************/
TVBAK = SELECT VBELN, NETWR
FROM "SAPABAP1"."VBAK";
END;
but when activating the procedure this error shows
I've granted all privileges for my user "HANAADMIN" over the schema HANAADMIN and select privilege over the schema SAPABAP1.
Is there is anything I am missing??
Hello Ibrahem,
What about privileges on _SYS_REPO for your user HANAADMIN? It sounds to me you need priveleges on _SYS_REPO catalog as well since you have been creating / using repository objects.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Tuncay,
It worked after granting privilege to _SYS_REPO user on HANAADMIN schema.
GRANT SELECT on schema HANAADMIN to _SYS_REPO
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.