SQL Server Performance

Securitty

Discussion in 'SQL Server 2005 Reporting Services' started by jastone, Jan 25, 2007.

  1. jastone New Member

    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
  2. satya Moderator

    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.

Share This Page