Skip to Content
May 17, 2016 at 11:47 AM

SQL syntax to grant application privileges to Catalog roles


Hi All,

I am working on creation of Catalog Roles. And I need to add the application privilege

sap.hana.admin.cockpit.sysdb::WidgetAccess:sysdbadmin sap.hana.admin.cockpit.sysdb::SysDBAdmin

to a catalog Role. (I am not talking about repository roles)

and below syntax

GRANT sap.hana.admin.cockpit.sysdb::SysDBAdmin to ZROLE does not work.

For sure something in the syntax is missing, but I am not sure what is correct.