Viewing 2 posts - 1 through 2 (of 2 total)
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...
May 6, 2011 at 7:32 am
#1321006
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?
May 5, 2011 at 1:53 am
#1320240