Skip to main content

MySQL - Permission - Set Custom Table Permissions

Summary​

This script will gather all users in the database and grant all required rights to any custom ProVal tables.

Time Saved by Automation: 5 Minutes

Sample Run​

Sample Run

The script is converted to a client script and should be scheduled to run every 2 hours.

Variables​

NameDescription
UpdateStatementsThis variable will store the SQL result, which will be further used as an update statement to grant permission to custom ProVal tables.

Changelog​

2025-04-10​

  • Initial version of the document

2025-03-12​

  • Updated the script to set permissions for 'proval_|pvl_' instead of 'proval|pvl_'. Earlier the query was taking too long to run.