The Server Logins and User Mappings report shows all Server Logins and associated Database User Mappings for each SQL Server, Azure SQL Database, and Amazon RDS for SQL Server instance being audited.
Recommendation
Review this report to ensure each Login has only the mappings to the databases it should access.
Getting Started
Follow these steps to create a report:
- Select the Date, Policy, and Baseline options from the Report Settings box.
- Select a target instance.
- Select a Database you would like to analyze.
- Choose the type of Login.
- Type or browse for the User name.
- Click the View Report button to generate your report.
Note
Consider that the screenshot above was modified. You can find a complete view on SQL Secure console.