Skip to main content
B
bihitakd0001
January 16, 2023
Solved

Prevent accident running of truncate and delete query

  • January 16, 2023
  • 3 replies
  • 0 views

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

    Best answer by stewart.burchell

    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.

    3 replies

    R
    rahuls0014
    January 17, 2023

    Hi Bihitak there are 2 solutions to this,
    1. According to me Inside the SQL we have a feature of locking the database table which would prevent the running of these two queries.
    2. To prevent execution of truncate or delete query, you can create a Foreign Key constraint on an other dummy database table event without any data but only referencing to main table.

    stewart.burchell
    stewart.burchellAnswer
    January 17, 2023

    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.

      S
      surjitg0001
      January 17, 2023

      Another way to avoid accidental delete is to run the queries in Transaction and only commit if you are sure you have run it on correct database/table and ran correctly.

      But does the phpMyAdmin supports Start Transaction , Commit and Rollback. I tried it it did not work. Has anyone used these commands in phpMyAdmin, if yes can you please share how did you run it?

      Terms & ConditionsAccessibility statement