Issue:
feat(roles): edge cases for multi-tenancy - I

Add tenant_id in custom roles
Add generic query to search across all tenants
Close https://github.com/juspay/hyperswitch-cloud/issues/7998
Close https://github.com/juspay/hyperswitch-cloud/issues/7998
Close https://github.com/juspay/hyperswitch-cloud/issues/8026

Resolution:
<think>
PR Context:
- Title: feat(users): handle edge features for users in tenancy
- Merged: 2025-01-08T09:34:23Z
- Files changed: 18 files
- Commits: 9 commits

Implementation approach:
## Type of Change
<!-- Put an `x` in the boxes that apply -->

- [x] Bugfix
- [x] New feature
- [ ] Enhancement
- [ ] Refactoring
- [ ] Dependency updates
- [ ] Documentation
- [ ] CI/CD

## Description
This PR
- add tenant_id in roles table
- add support for genenric query to serach user across all tenancies
- Fixes custom roles creates by tenant_level user
- List view for tenant level user
- Fix bug to search across envs for tenant admin

### Additional Changes

- [ ] This
</think>

To implement this, you'll need to modify:


**Detailed Implementation:**


**Commit 1:** feat(users): handle edge features for users in tenancy (#6990)
Files to modify:


**crates/diesel_models/src/query/role.rs**
  Modify existing code

**crates/diesel_models/src/query/user_role.rs**
  Add:
    - function: pub::list_user_roles_by_user_id_across_tenants

**crates/diesel_models/src/role.rs**
  Modify existing code

**crates/diesel_models/src/schema.rs**
  Modify existing code

**crates/diesel_models/src/schema_v2.rs**
  Modify existing code

**crates/router/src/analytics.rs**
  Modify existing code

**crates/router/src/core/user.rs**
  Modify existing code

**crates/router/src/core/user_role.rs**
  Modify existing code

**crates/router/src/core/user_role/role.rs**
  Modify existing code

**crates/router/src/db/kafka_store.rs**
  Add:
    - function: private::list_user_roles_by_user_id_across_tenants

**crates/router/src/db/role.rs**
  Modify existing code

**crates/router/src/db/user_role.rs**
  Add:
    - function: private::list_user_roles_by_user_id_across_tenants
    - function: private::list_user_roles_by_user_id_across_tenants

**crates/router/src/services/authorization.rs**
  Modify existing code

**crates/router/src/services/authorization/roles.rs**
  Modify existing code

**crates/router/src/utils/user.rs**
  Modify existing code

**crates/router/src/utils/user_role.rs**
  Modify existing code