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 a login at the server level create login \[ username ] with password = ’\<password >’; \ grant server level permission to view server state grant view server state to \[ username ]; \ create a user under each required database use \[ database name ]; create user \[ username ] from login \[ username ]; \ optionally , grant permission to view definitions (e g , for masking ) grant view definition to \[ username ]; testing permissions connect as \[username] and execute mssql select from sys dm os sys info ; if \[username] can see the system info, it confirms that view server state is functioning correctly