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
Corey A. Rector
Ensite Inc.
Omaha, NE
** If you've got the time, we've got the beer. **