SQL Server (2005 or other) - Permissions on Views Excel Connection
- From: christophe.leroquais@xxxxxxxxx
- Date: 29 May 2006 09:15:37 -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: Re: SQL 2005 Express-Database does not have a valid owner?
- Next by Date: Re: SQL 2005 Express-Database does not have a valid owner?
- Previous by thread: SQL 2005 Express-Database does not have a valid owner?
- Next by thread: do not display system views - connection via Excel
- Index(es):
Relevant Pages
|
|
