Unanswered: SQL7 List of users/rights on tables-views-SP
I'm looking for a trick by which I could extract a COMPLETE LIST
of ALL USERS and their rights (INSERT/DELETE/EXECUTE etc.) on
ALL OBJECTS such as tables, views and stored procedures in MSSQL 7.
Via sp_table_privileges I managed to extract all relevant rights for every
user on all tables in a specific database.
However this SP does not extract the same data concerning views and/or
stored procedures in the same database.
Maybe I didn't look in the right places.
Anyuseful tip / trick to extract this (in table-format) is welcome.