STRLCPY/GOAD

■ ■ ■ ■ ■ ■

ad/sevenkingdoms.local/data/config.json

		skipped 72 lines
73	73		"NORTH\\jon.snow"
74	74		],
75	75		"executeaslogin" : {
76		-	"NORTH\\samwell.tarly" : "sa"
	76	+	"NORTH\\samwell.tarly" : "sa",
	77	+	"NORTH\\brandon.stark" : "NORTH\\jon.snow"
77	78		},
78	79		"executeasuser" : {
79		-	"NORTH\\arya.stark" : "dbo"
	80	+	"arya_master_dbo": {
	81	+	"user": "NORTH\\arya.stark",
	82	+	"db" : "master",
	83	+	"impersonate" : "dbo"
	84	+	},
	85	+	"arya_dbms_dbo": {
	86	+	"user": "NORTH\\arya.stark",
	87	+	"db" : "msdb",
	88	+	"impersonate" : "dbo"
	89	+	}
80	90		},
81	91		"linked_servers": {
82	92		"BRAAVOS" : {
		skipped 455 lines

■ ■ ■ ■ ■ ■

ansible/roles/mssql/tasks/main.yml

		skipped 139 lines
140	140		- name: Add IMPERSONATE on user
141	141		win_shell: \|
142	142		SqlCmd -E -Q "CREATE LOGIN [{{item.key}}] FROM WINDOWS"
143		-	SqlCmd -E -Q "CREATE USER [{{item.key}}] FOR LOGIN [{{item.key}}]"
144		-	SqlCmd -E -Q "GRANT IMPERSONATE ON USER::[{{item.value}}] TO [{{item.key}}]"
	143	+	SqlCmd -E -Q "USE {{item.value.db}};CREATE USER [{{item.value.user}}] FOR LOGIN [{{item.value.user}}]"
	144	+	SqlCmd -E -Q "USE {{item.value.db}};GRANT IMPERSONATE ON USER::[{{item.value.impersonate}}] TO [{{item.value.user}}]"
145	145		become: yes
146	146		become_method: runas
147	147		become_user: "{{SQLSVCACCOUNT}}"
		skipped 52 lines