Procedure failed

[Former Member]

Hello,

   I'm calling a procedure (created in AFM) in sql console and it failed. Can someone guide me in what privileges do I need to provide.

User: AFMUSER

Schema: AFMUSER

Error: "Could not execute 'Call "AFMUSER". rts::test.model" ("AFMUSER"."MLR_INPUT", #CONTROL,...'

            SAP DBTECH JDBC: [258]: insufficient privilege: not authorized

Thanks,

Vijay.

[Former Member · Accepted solution]

Hello Vijay,

User 'AFMUSER' should be assigned with role AFL__SYS_AFL_AFLPAL_EXECUTE. Also 'AFMUSER' should  have SELECT privilege on Schema 'AFMUSER'.

Thanks,

Venu

[Former Member · Accepted solution]

Thanks Venu, its working fine now.