HANA Stored Procedures.. Insufficient Priv when Executing & How does default schema work?
Hi - I am very new to the HANA development. What i am trying to do is create a stored procedure which access data from standard SAP tables (tables from SAPDEC schema). I am stuck up with 2 issues and hence would help from the experts here.
(a) When i try to execute the stored procedure, I am getting the below error saying "SAP DBTech JDBC: : insufficient privilege: Not authorized". The database user have SELECT access on the SAPDEC schema. Does the DB user need to have "EXECUTE" access on the HANA procedure created on "Object Privileges" tab?
(b) I have set the default schema for the procedure to SAPDEC schema. Now when the stored procedure is transported to the QA environment, how will this HANA procedure work as the schema in QA would be say SAPQEC (that's where the standard SAP tables are stored? Will the default schema in the procedure definition have to be changed to SAPQEC manually in the QA environment?