I have a table that contains rows, obviously. Each of the rows in my table represents a different report. I would like to use role based security to manage which user has access to which report. What I'll do is fill a listview and give them the ability to select and print multiple reports at once. When I fill the listview, I'll only want it to fill it with rows(reports) that this user has access to.

I hope this makes sense.

You're saying that the column in the Reports table would contain the permissionkey and then use that permission key to look up the permission at runtime? If I had 50 records to check and then add to the listview would that cause a considerable processing lag?

When you say security documentation do you mean the Role-Based Security Help file or security documentation in general? Because I have read most of the RBS help file and very little on security in general. Everything we do is in house and not exposed to the outside world so there is little need beyond basic permissions.

Thanks. Your suggestion will help. Because what I would like to have is one central way to manage permissions and I like what RBS has to offer.

Yes.

No.  These requests are scalar, so it will be fast.  If you have a problem, show all of the reports and just test the security when the end-user tries to run the report.

It is the Security Help.chm file.  Attached here is the latest version in case you do no have it downloaded.