Create a proxy user and grant access to the schema : LOGIN « User Role « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. User Role
3. LOGIN

5> CREATE USER Alejandro
6> WITHOUT LOGIN
7> GO
1>
2> GRANT SELECT ON SCHEMA::Sales
3> TO Alejandro
4> GO
Msg 15151, Level 16, State 1, Server J\SQLEXPRESS, Line 2
Cannot find the schema 'Sales', because it does not exist or you do not have permission.