Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Create roles CREATE ROLE 'app_read', 'app_write', 'app_admin'; -- Grant privileges to roles GRANT SELECT ON myapp.* TO 'app_read'; GRANT SELECT, INSERT, UPDATE, DELETE ON myapp.* TO 'app_write'; GRANT ALL PRIVILEGES ON myapp.* TO 'app_admin'; -- Assign roles to users GRANT 'app_read' TO 'report_user'@'%'; GRANT 'app_write' TO 'app_user'@'localhost'; -- Set default roles SET DEFAULT ROLE 'app_write' TO 'app_user'@'localhost'; -- View active roles SELECT CURRENT_ROLE();
Result
Open