1 | CREATE USER username FROM LOGIN login; |
2 | |
3 | EXEC sp_addrolemember 'db_datareader', 'username'; |
4 | |
5 | EXEC sp_addrolemember 'db_datawriter', 'username'; |
Last active
Very good script
1 | CREATE USER username FROM LOGIN login; |
2 | |
3 | EXEC sp_addrolemember 'db_datareader', 'username'; |
4 | |
5 | EXEC sp_addrolemember 'db_datawriter', 'username'; |