Security Query

[btd]

I am trying to query the database for a listing of security rights.

So far I have developed this query. While this seems to work, I found out that if I don't click the repository in the Repository Access list of "Security Settings for Users" tab, my users don't see the Repository in their listing.

So what table is controls if the repository shows up in their list when they log on?

Thanks

Also do you see anything wrong with my query?

SELECT
tblusers.name,
tblrepositories.name as Repository,

case WHEN tblsecurityassignments.securityrights=1 OR tblsecurityassignments.securityrights=3 OR tblsecurityassignments.securityrights=7 THEN 'Y' ELSE 'N' END AS ReadRights,

case WHEN tblsecurityassignments.securityrights=3 OR tblsecurityassignments.securityrights=7 THEN 'Y' ELSE 'N' END AS CheckOutInRights,
case WHEN tblsecurityassignments.securityrights=7 THEN 'Y' ELSE 'N' END AS AddRemoveDeleteRights

FROM
tblsecurityassignments INNER JOIN
tblusers ON tblsecurityassignments.userid = tblusers.userid INNER JOIN
tblrepositories ON tblsecurityassignments.repid = tblrepositories.repid
where tblusers.active = 1

ORDER BY tblusers.name, Repository

[ian_sg]

You're looking for tbluserrepositories. The presence of a record with a userid x and repid y indicates that user x sees repository y.