hello.sql
· 192 B · MySQL
Orginalformat
CREATE USER username FROM LOGIN login;
EXEC sp_addrolemember 'db_datareader', 'username';
EXEC sp_addrolemember 'db_datawriter', 'username';
EXEC sp_addrolemember 'db_ddladmin', 'username';
| 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'; |