Object Privilege in design time role creation

[former_member193552]

We have remote source and we want to add it to a role. Is this right syntax?

"object_privileges":[
{
"name":"PSX_CDO",
"type":"REMOTE SOURCE",
"privileges":[ ],
"privileges_with_grant_option":[ "CREATE VIRTUAL TABLE" ]
}
]

}

[pfefferf]

If you are asking in the context of XSA, then it is correct.

[former_member193552]

I want to do in in sp12. Not in XSA.

So I have design time role and i wanted to add this remote source. It give syntax error. How do i add in hana1.0 sp12.

[pfefferf]

As said in my answer, the syntax snippet in your question is correct for XSA. But in your comment it can be seen that you are trying to create a role in XSC mixed with the XSA syntax. In case you wanna (still) create a role via XSC you have to apply the correct syntax. For details please check the official help for that.