printing privileges

[jsilver]

Hi,

I'm new to Cognoise community.  I found a helpful topic regarding users and their associated groups (topic: 3079.0, Report on Users / Roles / Groups and Permissions).  The sample SQL works great.  I would like to take this one step further.  I would also like to print specific privileges on specific folders/reports/packages. For example, you may know that john.q.public belongs to the "public_users_sample" role, but what does the "public_users_sample" role have read/write/traverse privileges on?  Any help will be appreciated.