Like 0
Fork 0

Last active 1681553077

Very good script

tetete revised this gist 1681553077. Go to revision

1 file changed, 3 insertions, 1 deletion

hello.sql

@@ -2,4 +2,6 @@ CREATE USER username FROM LOGIN login;
2 2
3 3 EXEC sp_addrolemember 'db_datareader', 'username';
4 4
5 - EXEC sp_addrolemember 'db_datawriter', 'username';
5 + EXEC sp_addrolemember 'db_datawriter', 'username';
6 +
7 + EXEC sp_addrolemember 'db_ddladmin', 'username';

tetete revised this gist 1681553050. Go to revision

1 file changed, 5 insertions

hello.sql(file created)

@@ -0,0 +1,5 @@
1 + CREATE USER username FROM LOGIN login;
2 +
3 + EXEC sp_addrolemember 'db_datareader', 'username';
4 +
5 + EXEC sp_addrolemember 'db_datawriter', 'username';
Newer Older

Powered by Opengist ⋅ Load: 14ms⋅

English
⋅ Discord