SQL Server (2005 or other) - Permissions on Views Excel Connection
- From: christophe.leroquais@xxxxxxxxx
- Date: 29 May 2006 09:16:24 -0700
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
.
- Prev by Date: Remote connect and encounter SQL Server does not exist or access denied.
- Next by Date: Re: Remote connect and encounter SQL Server does not exist or access denied.
- Previous by thread: Remote connect and encounter SQL Server does not exist or access denied.
- Next by thread: do not display system views - connection via Excel
- Index(es):
Relevant Pages
|
