Mega Code Archive

 

Categories / MSSQL Tutorial / User Role

 

Managing Fixed Database Role Membership

USE YourDatabaseName GO EXEC sp_addrolemember 'db_datawriter', 'YourName' EXEC sp_addrolemember 'db_datareader', 'YourName'