Unable to call RS_GRANT_ACCESS on tables with special character

[Former Member]

Hello All

I'm trying to run a procedure as SYSTEM user in the HANA Studio but it does not recognise the "/" character in the table name. Has anyone come across this problem when running RS_GRANT_ACCESS procedure, and how did you resolve it?

call SAPDEF.RS_GRANT_ACCESS('/ABC/ARTICLE_Z','Z_ROLE','X','','','')

Could not execute 'call SAPAFS.RS_GRANT_ACCESS('/ABC/ARTICLE_Z','Z_ROLE','X','','','')' in 147 ms 778 µs Started: 2012-10-05 11:33:18. SAP DBTech JDBC: [257]: sql syntax error:  [257] SAPDEF.RS_GRANT_ACCESS: line 1 col 1754 (at pos 1753): SQLException257 exception: sql syntax error: incorrect syntax near "/": line 1 col 17 (at pos 17)

Thank you.

[Former Member]

Soyful,

Drag the table name from the corresponding schema into the call statement instead of typing the table name. See if this works. Normally we use "<SchemaName>"."<TableName>"

Regards,

Vijay

[Former Member]

Vi Vijay

I've tried that but it doesn't work - table not found.

Thanks.

Soyful

[Former Member]

Could not execute 'call SAPDEF.RS_GRANT_ACCESS('/ABC/ARTICLE_Z','Z_ROLE','X','','','')' in 147 ms 778 µs Started: 2012-10-05 11:33:18. SAP DBTech JDBC: [257]: sql syntax error:  [257] SAPDEF.RS_GRANT_ACCESS: line 1 col 1754 (at pos 1753): SQLException257 exception: sql syntax error: incorrect syntax near "/": line 1 col 17 (at pos 17)