The “Is local” column indicates if this user is automatically synchronized to all aggregators or not. If sync_permissions is enabled on your cluster then all users other then root will be SYNC users.
The connections column shows how many connections are logged in with that user.