Skip to main content
Kofax

Missing tables In KSMS 6.7 when successfully connecting to a SQL Server 2017

3018435

Question / Problem: 

In KSMS 6.7 when connecting to a SQL Server 2017, we login fine, but we do not see any tables, or views, why?

Answer / Solution: 

Granting public, "View any database", and "View any definition" were the only permissions needed to view Databases in KSMS 6.6. You can grant permissions to "View any database" and "view any definition" under Login Properties | Securables | Explicit in SQL Server Management Studio. 

Applies to:  

Product Version
KTA 7.x

 

 

  • Was this article helpful?