Loading

how to check if a logged in user has a certain department ID

shosho shosho

I have a table that has a user Id and aswell the Id of the department he/she belongs to.

Now i want to write a code a to check if the logged in user belongs to department A OR B, if they belong to either one of them , then they have certain access rights. (otherwise none)

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Syed Shanu11y ago
Hi,
You can write a join query and get user detail and Depatment name.
for example

Select a.UserName,B.DepartmentName
from yourUserTable a
Inner Join
DepartmentName B
ON a.DeptID=B.DeptID
where
a.UserID='LoggedInUserID'

with the aboue result you can find the department of logged in user.

using this result you can perform your requirement.
0