I'm creating a database with a few different schemas.
99% of users connect using Excel, and when they do they see all the system stuff:
This just confuses the users and I would like to configure SQL Server so that they only see UK_data and UK_reports.
So far I tried denying select on the things that I want to hide and only allowing select on the UK_ schemas, but it didn't work.
Is there a way to hide them from users?