This is a discussion on SQL Server (2005 or other) - Permissions on Views Excel Connection within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi, I'm using SQL Server 2005. I would like to allow remote (unidentified) users to only see Views in ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I'm using SQL Server 2005. I would like to allow remote (unidentified) users to only see Views in the Excel ODBC Connection window. At the moment, when a user opens the Excel ODBC connection window, it displays all the objects: master DB, TempDB .... with all the tables, views... How to manage permissions/roles (I'm a bit confused with all that)...etc.... to see only the objects I would like to appear? Thanks, Chrisotphe |
| Thread Tools | |
| Display Modes | |
|
|