Archives of the TeradataForum
Message Posted: Wed, 22 Oct 2008 @ 21:27:59 GMT
| Subj: | | Re: Teradata/access |
| |
| From: | | Fred W Pluebell |
I think your problem stems from Access wanting to populate a complete list of all available tables/views for the user to pick from. By default
the driver uses HELP DATABASE to do that, which requires "any" database-level permission.
Preferred solution for the situation you describe would be to configure the ODBC driver options DontUseHelpDatabase=Yes (called "No HELP
DATABASE" in the GUI) and perhaps also UseXViews=Yes. But that has to be done on each client PC.
If you can't change the client setup, a workaround is to grant some "effectively NULL" permission at the database level, e.g. CHECKPOINT if
there are no permanent journals, EXECUTE PROCEDURE if there are no stored procedures, etc.
| 
