SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Intellisense doesn't show all schemas

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Intellisense doesn't show all schemas
Author Message
anp@ambientasgr.com



Joined: 24 Feb 2025
Posts: 2
Country: Italy

Post Intellisense doesn't show all schemas Reply with quote
Hi.
I'm using Sql Assistant 13.0. I'm using it since more than one year with no probs with SQLSERVER 2017. Now we are migrating to a new instance with the same database, but the intellisense doesn't show all schemas.
I can see schemas like [domain\user] or the schena dbo. Other schemas (like Staging, created with dbo as owner) aren't shown and even if I start to write Staging.TableName, after typing Staging. the list of table under the Staging schema isn't visualized.

Thanks for your help

Best
Andrea
Fri Aug 01, 2025 3:58 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7976

Post Reply with quote
Hi Andrea, this is a permissions issue. Granting VIEW DEFINITION permission at the database level to your user, or specific permissions on the schema or objects, can resolve this.
Fri Aug 01, 2025 8:46 am View user's profile Send private message
anp@ambientasgr.com



Joined: 24 Feb 2025
Posts: 2
Country: Italy

Post Reply with quote
At database/server level? can you suggest me a script or something similar?
At a first glance, it seems that I have identical permission on both server/databases
Thanks a lot

EDIT: I tried this

GRANT VIEW definition ON SCHEMA::Dimensions TO [domain\myuser]

but the schema Dimensions isn't showed in intellisense

EDIT 2:
I solved the issue adding to the Schema query in DBQueries the following

or @@version like 'Microsoft SQL Server 2022%'

Now all schemas are correctly showed in the intellisense
Fri Aug 01, 2025 9:32 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.