| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL Server (2005 or other) - Permissions on Views Excel Connection
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SQL Server (2005 or other) - Permissions on Views Excel Connection
That's a question you should be asking in a SQL Server newsgroup.
MH wrote in message ups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 with SQL Server Analysis Services 2005 | Excel Discussion (Misc queries) | |||
| Import data from Excel to SQL Server 2005 | Excel Discussion (Misc queries) | |||
| how to make Excel linked to SQL Server 2005 worksheet editable? | Excel Discussion (Misc queries) | |||
| How to connect the Excel 2007 in SQL Server 2005? | Excel Worksheet Functions | |||
| Excel VBA connection to SQL Server using ADO | Excel Programming | |||
Linear Mode
