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