SQL - Users, Roles & Permissions
Overview
Manage access with users/roles and GRANT/REVOKE. Syntax varies across engines and versions.
CREATE USER 'reporter'@'%' IDENTIFIED BY 'strongpass';
GRANT SELECT ON company.* TO 'reporter'@'%';
REVOKE SELECT ON company.* FROM 'reporter'@'%';
DROP USER 'reporter'@'%';
CREATE LOGIN reporter WITH PASSWORD = 'StrongPass!123';
CREATE USER reporter FOR LOGIN reporter;
EXEC sp_addrolemember 'db_datareader', 'reporter';
EXEC sp_droprolemember 'db_datareader', 'reporter';
DROP USER reporter;
DROP LOGIN reporter;
-- SQLite has no users/roles; access is enforced at the file/OS layer.