Technology LearningCheat Sheet
DATABASECHEAT SHEETS
SHEET 11
Users, Roles and Privileges
M.R. Sterling
Database Advanced · Sheet 11
Users, Roles and PrivilegesMySQL
Run on a real MySQL server, one login at a time: CREATE USER, roles, GRANT and REVOKE, the default role a new account needs, SHOW GRANTS, an audit trail that names the person, and a stored procedure.
$4.50Get this sheet
Or get all 6 in the Database Cheat Sheets: Advanced Pack for $19, or with the whole Health Data Clinic series in the Health Data Clinic - Complete + Cheat Sheets for $109.
Instant PDF downloadsent the moment you pay
Two A4 pagesprint front and back
MySQLevery query runs as printed
Keep it foreverno expiry, no account
What the sheet looks like
A blurred preview, to show the layout and how much fits on the two pages. The full, print-sharp sheet comes with your download.
What is on this sheet
Who sees what
CREATE USER
Roles
A granted role starts switched off
Checked on every statement
SHOW GRANTS
REVOKE
An audit trail
A stored procedure
The books this sheet pairs with
The sheet reminds you. These books teach it, one idea at a time, with every example worked.
More Database Advanced sheets
One email when a new book lands
No schedule, no filler. Just the new titles and the odd free chapter.