Archives of the TeradataForum

Message Posted: Thu, 17 Nov 2005 @ 16:04:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>