>Does anyone know if you can create a remote view of a SQL Server view. The reason that I want to do this is because I need to be able to limit the subset of data that a user can get at using the SQL Server permissions. The only way that I found to do this is by using views in SQL Server. Then I need to create a remote view of that data. The users don't have permissions to do anything with the underlying table.
>
>Any help would be appreciated.
>
>Corey
As I understand the situation, your users are not allowed to change data at all. If it's right, then what's the necessity to use remote views at all? Use pass-through SQL to run some stored procedure which hopefully will return some data from server for viewing purposes only.
Edward Pikman
Independent Consultant