Limit access to functions of the query Service | Community
Skip to main content
D
DavidQuintana
May 25, 2023
Question

Limit access to functions of the query Service

  • May 25, 2023
  • 1 reply
  • 1037 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Tof_Jossic
Adobe Employee
Tof_JossicAdobe Employee
Adobe Employee
June 12, 2023

@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:

 

Terms & ConditionsAccessibility statement

Loading footer...