Securitty | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


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
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.

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |