Archives of the TeradataForum
Message Posted: Thu, 17 Nov 2005 @ 16:04:52 GMT
The DBC.Users view only shows the current user, that user's descendants, and users for which the current user has explicit DROP permission. So only DBC is assured of getting a complete list.
Depending on what columns you want, you may be able to get the info from DBC.Databases WHERE DBKind='U' instead.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|