Question / Problem:
What SQL Server Permissions are Needed to Select a Database Name in KSMS?
Answer / Solution:
The minimum permissions needed to be able to select a SQL database in KSMS are View any database, View any definition, and Public. Follow the instructions below to grant these permissions.
- Log onto SQL Server Management Studio
- Navigate to Security | Logins then right click on the user and open Properties.
- To set Public go to Server Roles and check Public
- To set View any database and View any definition go to Securables | Explicit and Grant the two permissions.