User Role MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. User Role
  4. Managing Fixed Database Role Membership
USE YourDatabaseName
GO
EXEC sp_addrolemember 'db_datawriter', 'YourName'
EXEC sp_addrolemember 'db_datareader', 'YourName'