JavaScript routine support¶
Privileges control what users can do. You use them to give specific permissions to different users. This ability helps you keep your data secure by only allowing authorized users to access and change information in the database.
Privileges¶
To create routines, you must have the global dynamic CREATE_JS_ROUTINE privilege in addtion to the standard CREATE ROUTINE privilege.
mysql> GRANT CREATE_JS_ROUTINE ON *.* TO user1@localhost;
If a user can create routines and has the CREATE_JS_ROUTINE privilege, they can now create stored functions and procedures using JS.
However, you can’t currently create JS triggers or events.
Get expert help¶
If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.
Last update:
2025-01-10