| 1 | CREATE USER username FROM LOGIN login; |
| 2 | |
| 3 | EXEC sp_addrolemember 'db_datareader', 'username'; |
| 4 | |
| 5 | EXEC sp_addrolemember 'db_datawriter', 'username'; |
| 6 | |
| 7 | EXEC sp_addrolemember 'db_ddladmin', 'username'; |
最後活躍
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'; |
| 6 | |
| 7 | EXEC sp_addrolemember 'db_ddladmin', 'username'; |