Fix to use dbauthz system user

Emyrk · Emyrk · commit f035f9a90ce9 · 2023-04-13T10:54:09.000-05:00
diff --git a/coderd/provisionerjobs.go b/coderd/provisionerjobs.go
@@ -224,7 +224,7 @@ func (api *API) provisionerJobResources(rw http.ResponseWriter, r *http.Request,
 	}
 
 	// nolint:gocritic // GetWorkspaceAppsByAgentIDs is a system function.
-	apps, err := api.Database.GetWorkspaceAppsByAgentIDs(ctx, resourceAgentIDs)
+	apps, err := api.Database.GetWorkspaceAppsByAgentIDs(dbauthz.AsSystemRestricted(ctx), resourceAgentIDs)
 	if errors.Is(err, sql.ErrNoRows) {
 		err = nil
 	}

Original file line number	Diff line number	Diff line change
`@@ -224,7 +224,7 @@ func (api API) provisionerJobResources(rw http.ResponseWriter, r http.Request,`
`224`	`224`	`}`
`225`	`225`
`226`	`226`	`// nolint:gocritic // GetWorkspaceAppsByAgentIDs is a system function.`
`227`		`- apps, err := api.Database.GetWorkspaceAppsByAgentIDs(ctx, resourceAgentIDs)`
	`227`	`+ apps, err := api.Database.GetWorkspaceAppsByAgentIDs(dbauthz.AsSystemRestricted(ctx), resourceAgentIDs)`
`228`	`228`	`if errors.Is(err, sql.ErrNoRows) {`
`229`	`229`	`err = nil`
`230`	`230`	`}`