Mega Code Archive
Create a proxy user and grant access to the schema
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.