SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




CRM Companies List
Web Based CRM Software


Could not create catalog object: insufficient privilege; Not authorized


When I tried to create HANA database repository procedure (HDB procedure) .hdbprocedure using SAP HANA Web-based Development Workbench Editor, I got following activation error: Could not create catalog object: insufficient privilege; Not authorized


Here is a simple HANA database procedure I created for test on my trial account database schema on hanatrial.ondemand.com portal

create HANA database HDB procedure hdbprocedure

Above HANA procedure created via .hdbprocedure file within a package named kodyaz

SQLScript developers can realize the only part is the SELECT statement that could cause following activation error.

File /kodyaz/HDBProcedure04.hdbprocedure saved successfully.
Error while activating /kodyaz/HDBProcedure04.hdbprocedure:
[kodyaz:HDBProcedure04.hdbprocedure] Could not create catalog object: insufficient privilege; Not authorized

Could not create catalog object: insufficient privilege; Not authorized

If you experience such a problem, remember that such repository procedures (.hdbprocedure) are created as "_SYS_REPO" although you won't be able see this procedure under _SYS_REPO schema. So this "insufficient privilege; Not authorized" erro shows that _SYS_REPO does not have the authorization to execute SELECT statement as required for this sample HANA procedure.

For the solution, I launched Security view on SAP HANA Web-based Development Workbench

Then you can grant SELECT permission on all objects created under KODYAZ schema within Object Privileges tab for _SYS_REPO user

grant SELECT privileges on schema for _SYS_REPO user on Object Privileges tab

By granting SELECT permissions on objects within a certain schema, _SYS_REPO user will be able to read all data on related database schema.
Database administrators can limit the SELECT permission on table level selecting the target table only instead of granting SELECT access to all schema objects.

Right after granting SELECT access, SQLScript developers can try to create the same HDB procedure and will get following success message.

File /kodyaz/HDBProcedure04.hdbprocedure saved & activated successfully.






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








Copyright © 2004 - 2018 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems