This question was migrated from Stack Overflow because it can be answered on Database Administrators Stack Exchange. Migrated 3 days ago. I have DatabaseX_2024 and DatabaseY on same SQL Server. My app works with DatabaseY but need some data from DatabaseX_2024. Because name of DatabaseX_2024 is changing (will be DatabaseX_2025 next year), I made synonym […]

I have many tables in the default dbo schema. I don’t want a user to be able to see the dbo tables. I only want the user to see a View. That View is selecting tables from dbo schema. I tried to create a new schema AA, and create the View in this AA schema. Then I run command: