Database Users and Roles

-- Create user
CREATE USER 'username'@'host' IDENTIFIED BY 'password';

-- Create role
CREATE ROLE role_name;

-- Grant permissions
GRANT SELECT, INSERT ON database.table TO role_name;

• 1Accounts that access the database.
• 2Each user has specific permissions.
• 3Can be restricted by host.
• 4Used for authentication.

• 1Groups of permissions.
• 2Assigned to multiple users.
• 3Simplify permission management.
• 4Improve security control.

• 1Users are assigned roles.
• 2Roles contain privileges.
• 3Permissions flow from roles to users.
• 4Centralized access control.

• 1SELECT - read data.
• 2INSERT - add data.
• 3UPDATE - modify data.
• 4DELETE - remove data.

• 1Improved security.
• 2Simplified administration.
• 3Better access control.
• 4Scalable permission system.

• 1Easy permission assignment.
• 2Reusable access groups.
• 3Reduces human error.
• 4Better security structure.

• 1Managing employee database access.
• 2Separating admin and user privileges.
• 3Securing sensitive business data.
• 4Controlling API database access.
• 5Enterprise security management.

• 1Giving all privileges to all users.
• 2Not using roles properly.
• 3Weak password policies.
• 4Ignoring privilege revocation.

• 1Use roles instead of individual permissions.
• 2Follow least privilege principle.
• 3Regularly review user access.
• 4Use strong authentication methods.