September 25, 2018 at 8:24 am
We would like to get a list of all db users and their permissions and report on them. Are there any utilities that allow this to be done easily without having to run direct queries in SQL? I am wondering if there are any 3rd party tools so we don't have to develop this in house. Ideally I would like management to be able to run this themselves quarterly.
September 25, 2018 at 8:29 am
SQL Server Reporting Services (SSRS) will do this for you. Other similar products are available. Even Excel could do it, although I don't necessarily recommend using that.
John
September 25, 2018 at 9:48 am
+1 to SSRS recommendation. I have a collection of database / server level permissions scripts that I run quarterly for our audits manually. Haven't bothered with putting them in SSRS because it is only 4 times / year that I need to pull that info.
September 25, 2018 at 11:19 am
The easiest way i know is to use Registered Servers in SSMS. Add all your servers to a group and run a query.SELECT name, type_desc, is_disabled, create_date, modify_date,default_database_name
FROM sys.server_principals
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply