We are currently performing maintenance on Appian Community. As a result, discussions posts and replies are temporarily unavailable. We appreciate your patience.
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 10 subscribers
  • Views 884 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Prevent accident running of truncate and delete query

bihitakdass
A Score Level 1

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

  Discussion posts and replies are publicly visible

Parents
  • 0

    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.

Reply
  • 0

    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.

Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.