MDL-62384 privacy: Modify user contexts query for auth_oauth2

diff --git a/auth/oauth2/classes/privacy/provider.php b/auth/oauth2/classes/privacy/provider.php
index 2ab7ff0..5a3476a 100644 (file)
--- a/auth/oauth2/classes/privacy/provider.php
+++ b/auth/oauth2/classes/privacy/provider.php
@@ -75,8 +75,7 @@ class provider implements
     public static function get_contexts_for_userid(int $userid) : contextlist {
         $sql = "SELECT ctx.id
                   FROM {auth_oauth2_linked_login} ao
-                  JOIN {user} u ON ao.userid = u.id
-                  JOIN {context} ctx ON ctx.instanceid = u.id AND ctx.contextlevel = :contextlevel
+                  JOIN {context} ctx ON ctx.instanceid = ao.userid AND ctx.contextlevel = :contextlevel
                  WHERE ao.userid = :userid";
         $params = ['userid' => $userid, 'contextlevel' => CONTEXT_USER];
         $contextlist = new contextlist();