Archives of the TeradataForum

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

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

nazy_gholizadeh:

I have never done a SHOW on the Users View, but from what it returns it acts like the X (restricted) views that contain a WHERE databasename=USER (in Teradata users and databases are pretty much the same thing with the exception of a PASSWORD). Therefore, it is impossible to get all users from this view. The only way to see all users would be to have access to the table called DBASE from which the Users view selects its information.

Hope this helps get you on the path to what you seek,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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