Archives of the TeradataForum
Message Posted: Mon, 14 May 2001 @ 14:35:02 GMT
| Subj: | | Re: Access to the Catalog |
| |
| From: | | Fred Pluebell |
You don't need database-level privileges just to run queries in MS Access. But when you are linking or importing data via ODBC, MS
Access wants to "enumerate" the objects in the database to build a selection list. (Same applies to MS Query add-in for MS Office.)
By default, the ODBC driver uses HELP DATABASE to obtain this list. That does require you to hold at least one permission on the
database as a whole - but it doesn't matter which permission. For example, you can grant EXECUTE permission on a database that contains
only end-user views.
Or you can configure the ODBC driver on the client PC to use SELECT from either DBC.Tables or DBC.TablesX views to build the list of
objects, rather than HELP DATABASE. That method allows you to list tables from multiple databases at once (which can be a very long list
for DBC.Tables).
On the other hand, managing access at the database level is typically a good practice - a lot fewer rows in AccessRights.
| 
