Prevent accident running of truncate and delete query

Question

Hi, 
 How to prevent running of truncate and delete query accidentally on database table. 
 Is there any role and access setup can be done to prevent this considering having "System Admin" access in APPIAN. 
 
 Regards 
 Bihitak

Stewart Burchell · Accepted Answer

You can control who can have access to the database admin console, and who can only have access as Designers on Appian applications (i.e. you can remove database access from Appian Designers by making them Basic Users with Designer rights only, and not Database rights). You could therefore restrict access to the database admin console to System Administrators only...this doesn't prevent the scenario you're describing but it does reduce the likelihood.

Prevent accident running of truncate and delete query

Top Replies