Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Grant read-only access to a specific database GRANT SELECT ON myapp_db.* TO 'report_user'@'%'; -- Grant DML permissions but not DDL GRANT SELECT, INSERT, UPDATE, DELETE ON myapp_db.* TO 'app_user'@'localhost'; -- Grant execute on a specific stored procedure GRANT EXECUTE ON PROCEDURE myapp_db.GetCustomerOrders TO 'app_user'@'localhost'; -- View a user's privileges SHOW GRANTS FOR 'app_user'@'localhost'; -- Revoke a privilege REVOKE DELETE ON myapp_db.* FROM 'app_user'@'localhost';
Result
Open