Creating a login with the correct permissions
Published 26 June 2015
This page applies to DLM Dashboard 1.7.0 and later.
If you're using an earlier version of DLM Dashboard, or if you're changing the configuration of a server set up for monitoring in an earlier version, use the link available in DLM Dashboard when you add or edit the server. This will give you the appropriate setup script, login script and permissions information for your server configuration. See Add servers and database
Permissions
When you add a server, the login you connect with needs these permissions:
on the server:
VIEW ANY DEFINITION
on all databases you want to monitor:
SELECT ON sys.sql_expression_dependencies- on the database RedGate (created by the DLM Dashboard setup script):
SELECT ON SQLLighthouse.DDL_Events- E
XECUTE ON dbo.RG_SQLLighthouse_ReadEvents(created by the DLM Dashboard setup script)
If you have encrypted objects, the account needs the sysadmin role.
Create a login
We recommend you create a login for DLM Dashboard, which only has the permissions needed.
To do this:
- Run the server setup script on the SQL Server you want to monitor.
This creates the server objects that DLM Dashboard uses. For information about these objects, see About the DLM Dashboard server objects. - Download this create login script and open it in SSMS.
- You need to:
- change the password on line 3
- (optionally) change the login name on lines 3, 8, 21 and 27.
- copy lines 20-23 for each database you want to monitor, adding in the name the databases
- if you have encrypted objects, uncomment the encrypted objects section on lines 27-28.
- Run the script to create the login.
- In DLM Dashboard, go to the Configuration page. If the Add server section isn't visible, click Add a server.
- Enter the SQL Server's name, and the credentials you entered in the script.
- Click Add server.
The server is added to DLM Dashboard. You can now add databases to monitor.
