Owner retains full edit/delete permissions even when host is shared to their role
Root cause: The SQL query hostAccess.id IS NOT NULL marked hosts as "shared" whenever a hostAccess record existed, without checking if the current user is the owner.
Scenario:
Admin creates a host (owner)
Admin shares host to "Administrator" role
Admin is in "Administrator" role
hostAccess record exists → isShared = true
Frontend hides edit/delete buttons for shared hosts
Admin loses ability to modify their own host
Fix: Add owner check to SQL: hostAccess.id IS NOT NULL AND sshData.userId != userId
## Summary
- Fix `isShared` flag logic to exclude host owners
- Owner retains full edit/delete permissions even when host is shared to their role
**Root cause**: The SQL query `hostAccess.id IS NOT NULL` marked hosts as "shared" whenever a hostAccess record existed, without checking if the current user is the owner.
**Scenario**:
1. Admin creates a host (owner)
2. Admin shares host to "Administrator" role
3. Admin is in "Administrator" role
4. `hostAccess` record exists → `isShared = true`
5. Frontend hides edit/delete buttons for shared hosts
6. Admin loses ability to modify their own host
**Fix**: Add owner check to SQL: `hostAccess.id IS NOT NULL AND sshData.userId != userId`
Related to #391
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Summary
isSharedflag logic to exclude host ownersRoot cause: The SQL query
hostAccess.id IS NOT NULLmarked hosts as "shared" whenever a hostAccess record existed, without checking if the current user is the owner.Scenario:
hostAccessrecord exists →isShared = trueFix: Add owner check to SQL:
hostAccess.id IS NOT NULL AND sshData.userId != userIdRelated to #391