<div>
It is called SQL Security and you could go very deep into details or use views where you could also grant speciffic rights to SQL logins and hide the actual data tables as mayank_joshi suggested.<br />
<br />
<a href="http://www.microsoft.com/sqlserver/2005/en/us/security.aspx" rel="ugc">http://www.microsoft.com/sqlserver/2005/en/us/security.aspx</a>
</div>


It is called SQL Security and you could go very deep into details or use views where you could also grant speciffic rights to SQL logins and hide the actual data tables as mayank_joshi suggested.

http://www.microsoft.com/sqlserver/2005/en/us/security.aspx [http://www.microsoft.com/sqlserver/2005/en/us/security.aspx]

<div>
You can go down to column level permissions like below so only users entitled to perform certain actions against your data can do it:<br />
<br />
GRANT SELECT (&lt;column1&gt;, &lt;Column2&gt;,&lt;Column3&gt;) ON Employees TO [MyDOMAIN\user]<br />
<br />
DENY SELECT &lt;Column4&gt; ON Employees TO [MyDOMAIN\user]<br />
<br />

</div>


You can go down to column level permissions like below so only users entitled to perform certain actions against your data can do it:

GRANT SELECT (<column1>, <Column2>,<Column3>) ON Employees TO [MyDOMAIN\user]

DENY SELECT <Column4> ON Employees TO [MyDOMAIN\user]



<div>
<div class="content wysiwyg-content">
Experts.. I am in the process of migrating an old Sybase database to SQL server 2005. In Sybase I have proxy tables that point to a different database table. How and is there a way to create proxy tables in SQL Server. If there is no such tables, what is the alternative solution?
</div>
</div>


Experts.. I am in the process of migrating an old Sybase database to SQL server 2005. In Sybase I have proxy tables that point to a different database table. How and is there a way to create proxy tables in SQL Server. If there is no such tables, what is the alternative solution?

proxy tables in SQL Server

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.