Securitty | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Securitty

I want to be able to type a user/group’s name in and be able to see what rights they have to anything on my report server, is this possible? Example: type in: DomainNameHREmployee1 and it returns a list such as: HR Reports Browser
Payroll Reports Browser
Productivity Reports Browser
Report1 Browser
…. Thanks in advance Joe Janka
SP_HELPROTECT will return with such information on the database, if you want to format it with a reporting then yo have to work out. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>