Skip to Content
Former Member
Apr 11, 2015 at 02:52 AM

Remote Source Addition in Design Time Role


Wanted to see if if somebody has tried to add DROP privileges on a Remote Source in HANA Design time role. I have gone through the Guide and SAP help document but could not find how to add remote source privileges. SP09 security guide mentioned under Smart Data Access that Remote source is a SQL Object and I have tried to add it as a sql object (sql object ABC DS:DROP;) or catalog sql object ( even though I dont c it belongs to any schema in the OBJECTS view ) but getting syntax error. Also tried using WEB IDE but it does not seem to support Remote Source Object types. I can add the remote source in a run time role but we are only using design time roles

Secondly, is there a table or view which can list which Object is a Design time or runtime. For Example I was looking at SCHEMAS view and it even does not have design time schemas entries which I can see are available in WEB IDE

Create a Design-Time Role - SAP HANA Developer Guide for SAP HANA Studio - SAP Library