Thursday, July 12, 2012

Query to find Users and their Database Roles in SQL Server 2000


SELECT USER_NAME(memberuid) as UserName,
USER_NAME(groupuid) as Role
FROM sysmembers ;
MvM
Posted by at
Labels: , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)