Limit access to functions of the query Service

[DavidQuintana]

Hello,

Is there a way to limit the use of functions in query service? We need to know if you can limit the use of SQL functions to users so that they can only use query functions? the idea is to prevent them from using functions like DROP SCHEMA, DROP DATABASE, DROP VIEW, REMOVE SCHEMA. 

we only want it to have profiles to consult, but not to modify or delete

regards

[Tof_Jossic]

@DavidQuintana You may get additional content from other folks but I would look into the AEP permissions with this document - https://experienceleague.adobe.com/docs/experience-platform/access-control/home.html?lang=en

I don't believe you can set anything up at Query level (the only permissions are to 'Manage Queries' or not). However setting up the restrictions at dataset and schema level should help as it would carry over to whatever that user tries to do in Query Service, something like: