Archives of the TeradataForum
Message Posted: Wed, 04 Feb 2009 @ 14:47:07 GMT
| Subj: | | Re: Using Xviews with Teradata Administrator |
| |
| From: | | Dempsey, Mike |
If you tell TDAdmin to use the X views it will only be able to retrieve those databases that the user has some kind of rights on. Therefore if
they have rights on a database, but not on the parent, they will not see that lower level database. (This is one reason that SQL Assistant does
not use a hierachy tree.)
The only solution is for the DBA to grant a (not useful) right on the parent databases to all those users who need to see the hierachy. (In
13.0 you can use the 'Show' right)
Mike Dempsey
Teradata Client Tools
| 
