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:

GRANT SELECT ON SCHEMA ::  AA TO User1
DENY SELECT ON SCHEMA ::  dbo TO User1

But when I login as User1, and select data from AA.View1, the database says:

The SELECT permission was denied on the object dbo.table1, dbo.table2, etc

How can I allow user to select data from the AA.View1 and don’t allow them to see any dbo tables?