Archives of the TeradataForum

Message Posted: Wed, 14 Jun 2006 @ 16:17:59 GMT

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

Srikanth,

The system will not allow you to create a USER with a NULL password. The query you are using to check the NULL password is against the wrong view.

The query against DBC.LOGONRULES is indicating that the users can logon from specific HOSTS without providing a password. It does not indicate that one does not exists.

If you are interested, to determine if a PASSWORD is NULL run a query against the DBC.DBASE table.

It would be highly unlikely for any of these IDs to have a NULL password. More likely someone change the logon rules via a GRANT LOGON statement to allow these IDs not to provide their password. Not a good idea, but that is another discussion.

Larry

Larry Finney
Integrated Database Strategy

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