Type of Change

• Bugfix
• New feature
• Enhancement
• Refactoring
• Dependency updates
• Documentation
• CI/CD

Description

• Currently user can enter the id password in the given tenancy and can reach to intermediate state even if it has no user role in the current tenancy. Though he won't be able to signin, still its better to have a check when entering credentials only.
• Also when deleting user after user role deletion, we need to search for its user role across tenancies.

Additional Changes

• This PR modifies the API contract
• This PR modifies the database schema
• This PR modifies application configuration/environment variables

Motivation and Context

Closes #7026

How did you test it?

Tried with signin where user exists but doesn't have any role in the given tenancy

Checklist

• I formatted the code cargo +nightly fmt --all
• I addressed lints thrown by cargo clippy
• I reviewed the submitted code
• I added unit tests for my changes where possible