Skip to Content
0
Jun 26, 2018 at 12:49 PM

Global stored procedures in HANA

262 Views

Hello,

It possible to create global stored procedures in HANA that are available from within any schema on the server? In MSSQL, for example, this is achieved by adding a stored procedure to the master database and prefixing it with sp_. I failed to add a stored procedure to the SYS schema because of the error: only internal SYS user can modify objects in SYS and _SYS_AUDIT schema.

Is there any way to have globally available stored procedures without createing a dedicated schema?