<div>
you can grant the user view definition to the schema you want them to be able to see objects <br />
<br />
grant view definition on schema::marketing to username<br />
<br />
and to select data<br />
<br />
grant select on schema::marketing to username<br />
<br />
to resetrict to the other schema<br />
<br />
deny select on schema::marketing to username
</div>


you can grant the user view definition to the schema you want them to be able to see objects

grant view definition on schema::marketing to username

and to select data

grant select on schema::marketing to username

to resetrict to the other schema

deny select on schema::marketing to username

<div>
sorry last one should be:<br />
<br />
grant select on schema::accounting to username
</div>


sorry last one should be:

grant select on schema::accounting to username

<div>
grant has a schema option here's the details.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms187940.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms187940.aspx</a>
</div>


grant has a schema option here's the details.

http://msdn.microsoft.com/en-us/library/ms187940.aspx [http://msdn.microsoft.com/en-us/library/ms187940.aspx]

<div>
<div class="content wysiwyg-content">
I have a sql login that i want to restrict to one schema, how can i do that?<br />
<br />
for example user1<br />
and <br />
marketing.customers<br />
accounting.customers<br />
<br />
I want user1 to only see marketing.customers. &nbsp;I have many more under the same schema. &nbsp;I want the user to me able to select from all the tables that exists for this schema. &nbsp;Is there a script for this?
</div>
</div>


I have a sql login that i want to restrict to one schema, how can i do that?

for example user1
and 
marketing.customers
accounting.customers

I want user1 to only see marketing.customers.  I have many more under the same schema.  I want the user to me able to select from all the tables that exists for this schema.  Is there a script for this?

sql server user restrict to one schema

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.