Mid SQL

Assign Roles to Users: Assign users to specific roles based on their job?

responsibilities.

Example (SQL Server):

  • - Create a role

CREATE ROLE Manager;

  • - Grant permissions to the role

GRANT SELECT, UPDATE ON Employees TO Manager;

  • - Assign the role to a user

EXEC sp_addrolemember 'Manager', 'john_doe';

In PostgreSQL or MySQL, you would follow similar steps using GRANT statements and role

management commands.

More from SQL Server Tutorial

All questions for this course