1

ServiceLayer query allowlist for UDT/UDO

 7 months ago
source link: https://community.sap.com/t5/technology-q-a/servicelayer-query-allowlist-for-udt-udo/qaq-p/13610411
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

ServiceLayer query allowlist for UDT/UDO

Hello everybody, 

I have a problem with the allowlist from the query service layer. For example, if I want to post the following query:



{
"SqlCode": "U_CS_PROD5",
"SqlName": "U_CS_PROD5",
"SqlText": "SELECT T0.Code FROM [@CS_BDE_MAIN] T0"

}


Then I get the response:

{
"error": {
"code": 702,
"message": {
"lang": "en-us",
"value": "Table '@CS_BDE_MAIN' not accessible"
}
}
}

I defined the table in the allowlist like this:

First test:
@CS_BDE_MAIN
Second test:
[@CS_BDE_MAIN]
Third test
CS_BDE_MAIN

Afterwards I always restarted the service layer.

However, I still get the same error message.

Do you have any idea what that could be?

Thank you very much

Levin


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK