question

kcjailbirds avatar image
kcjailbirds asked

Problems with views and ODBC

I have an application that uses ODBC to connect to SQL Server and gets a list of tables and views. A client is having problems seing the user defined views but can see the tables that were used to pull the data into the views. I am unable to create that scenario. Is there a way to deny priveleges to views to a user but at the same time give them ability to see the tables? If I can duplicate his situation, I might be able to give him a solution. Any suggestion would be appreciated.
odbcviews
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered
Yes it is wholly possible to have permissions that control which users can see which views or tables you choose. I would suggest that you create an account/login/user combination exactly as your user currently has so that you can replicate his problem. Check this http://msdn.microsoft.com/en-us/library/ms188371.aspx for how permissions are configured
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.