Microsoft SQL Server (MSSQL) Configuration

purpose in mssql, the aim is to create a login and user with minimal read privileges, such as view server state, and optionally the ability to view object definitions if required grant permissions mssql create login \[ username ] with password = ’\<password >’; grant view server state to \[ username ]; create user \[ username ] from login \[ username ]; under each database that will be connected to testing permissions connect as \[username] and execute select from sys dm os sys info ; if \[username] can see the system info, it confirms that view server state is functioning correctly