Rog Saber (5/29/2014)

---

I have 2 tables - a user table (TB_USERS) and a user customer table (TB_USER_CUST). I want to select all the users that share the same customer with the logged in user. I created a view that looks like this:

SELECT user_id, fname, lname, password, phone, email

FROM dbo.TB_USERS

WHERE (user_id IN (SELECT user_id FROM dbo.TB_USER_CUST

WHERE (cust_no IN (SELECT cust_no

FROM dbo.TB_USER_CUST

WHERE (user_id = USER))) OR (USER = 'dbo'))) AND (UPPER(domain) <> UPPER('SAMPLE'))

This works fine. However, the DBA has just implemented groups. So now when a user logs in, they are part of a group and my view no longer works. The problem is the keyword 'USER'.

Does anyone know how I can fox my view to take into account groups? If I use 'suser()' instead of 'USER', then it contains the domain name as well which won't works.