Skip to main content

Admin Permission

  • This feature provides administrators with the ability to grant or restrict permissions for executing cautionary SQL queries such as:
    • DROP TABLE
    • UPDATE_NO_WHERE
    • DELETE_NO_WHERE
    • TRUNCATE_TABLE

🚫 Restrictions for Admin Users​

  • Even admin users cannot add or edit their own permissions via the application for security purposes.
    Admin Permission Screen

➕ Adding Permissions​

  • Click Add Permissions to assign permissions to another user.

⚙️ Setting Permissions​

To configure permissions for a user, follow these steps:

  1. Select Username: Choose the user to whom permissions will be assigned.
  2. Select SQL Types: Choose from the following options:
    • ALL
    • DROP TABLE
    • UPDATE_NO_WHERE
    • DELETE_NO_WHERE
    • TRUNCATE_TABLE
  3. Choose Bypass Type:
    • RESTRICT: Prevents the user from bypassing cautionary queries.
    • BYPASS: Allows the user to bypass those queries.

🔄 Updating Permissions​

  • If a user already has BYPASS permissions assigned and later needs to be restricted, the RESTRICT option can be selected.
    • This will remove the previously assigned BYPASS permission and apply the restriction instead.