Skip to main content
Kofax

What SQL Server Permissions are Needed to Select a Database Name in KSMS?

307767

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.

  1. Log onto SQL Server Management Studio
  2. Navigate to Security | Logins then right click on the user and open Properties.
  3. To set Public go to Server Roles and check Public
  4. To set View any database and View any definition go to Securables | Explicit and Grant the two permissions.

Applies to:  

Product Version Category
KTM 6.7 KSMS
KTM 6.6 KSMS