No schema information in Visual Query Builder?

[JohnJPS]

We're using integrated authentication when connecting to various data assets in SQL Server; in one case a user has nothing displaying in her Visual Query Builder. Any ideas what sort of permission is lacking that would result in this, (assuming it's permissions related)?  We are on 10.1.6.11313.

[jdunkerley79 · Accepted solution]

Can you see the schema if you connect in SQL Server Management Studio?

You probably to GRANT access to View Definition on the database

[s_pichaipillai]

Connect to SSMS and run the below code

Use yourdatabasename

go

SELECT * FROM fn_my_permissions (NULL, 'DATABASE')

this iwill list the permission of the currently logged in user