Hi Folks,
i have extended the included EasyconnectSQL scripts to get more permissions out of SQL Servers.The zip file consits of the following files:
- AccountMembers.sql
- accounts.sql
- dba__job_arm_easyconnect_permissions.sql
- job_resources.sql
- server_resources.sql
The first two scripts are almost the same as the provided ones. The only change is that more login types are included.
The third file creates a sql server agent job which runs the script (server_resources.sql) to populate a table (msdb.dbo.tblPermissions).
This table is read by job_resources.sql.
The setup: Follow the instruction provided with EasyconnectSQL.
There two options to get the permissions.
- create the job and collect the permissions using job_resources.sql
- use instead server_resources.sql, but I don't recommend that because it may fail due to runtime issues.
I have attached some example screenshots.
Have fun.
Regards
Marcus