Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Null Password for SystemFe, Crashsumps, TDPUser and Sys_Calendar
 
From:   Larry.Finney

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.

SEL * from DBC.DBASE where PASSWORDSTRING IS NULL and ROWTYPE = 'U'

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023