Here is the code to list/view/report ALL objects permissions in SQL SERVER 2000. Code will extract DB_name, User Name, Object Name, Object Type, Action and Protect Type.

use master

go

Create View VUserRights

as

SELECT...

Are there any version to run it in SQL Server 2000? Or what needs to be changed to be able to run in SQL Server 2000?