SQL Server 2005/2008.
By default, on SQL Server any user can see only his login or NT Groups, which he belongs to (both through Security\Logins in SSMS and sys.server_princapals DMV). I need to permit one power user to see all SQL Server logins. But only see,
not change. Can you help me?
P.S. VIEW ANY DEFINITION helps, but this permissions are too much.
View Complete Post