need to list all user permissions

I've been asked for a cross-matrix of users and their permissions.

That is, for each user in the database I need to find the permissions he/she has against every table in the database. It makes no difference if permission has been granted explicitly, or thru a role, or thru a system privilege. Any body know of an existing script? Is there any combination of sys-owned tables (e.g. the $ tables) that would help me?

Thanx. Received on Sat Nov 06 2004 - 00:41:35 CST