 |
 |
Archives of the TeradataForum
Message Posted: Fri, 19 Aug 2005 @ 13:49:29 GMT
| Subj: | | Re: Permissions to DBC.Databases / DBC.Tables |
| |
| From: | | Al MacGowan |
Dempsey, Mike wrote...
| | I have never tried using the X views instead of the main views (with ODBC) but there is an option available in the ODBC Data Source that
allows you to select the X views. | |
| | You would of course also have to grant public on the X views (DatabasesX, TablesX and ColumnsX) in order for this to work. | |
That did the trick perfectly via SQL Assistant, and I'm sure anything else that connects via ODBC. Thank you for that.
Now, I just have to get my user to use the JDBC/ODBC Bridge as he's using a JDBC-based software package to connect...
Alistair MacGowan
Senior Database Administrator
| |
