The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Thursday, March 28, 2024 Login
Public

Mercury - query for users and permissions with bitmask 2/20/2008 1:50:27 PM

All glory goes to Kevin Niederhauser with an assist from Jeff Pickett ;

Here's what I did to get the data that I needed. the bit mask is on the groups table, column gr_group_id. It is related to the (int) column on the users table...us_group.

 

SELECT sa.full_name, gr_group_name from

[USERS] u, [GROUPS] g, [qcsiteadmin_db].[td].[USERS] sa

where substring(u.us_group, g.gr_group_id + 1, 1) = '1'

and u.us_username = sa.user_name

order by sa.full_name

 


Blog Home