Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 11 Aug 2000 @ 09:06:50 GMT


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


Subj:   Re: Changing logon strings
 
From:   Bill Grenwelge

Charles,

To remove the blank in the users account string you will need to modify that user. you can run a query against DBC.Accountinfo to find all the users that have a blank in their accountstring such as

select * from dbc.accountinfo where accountname like '% %';

This should give you anything that has a blank space in it.

To modify the user you will need to use the id that created the user and issue the following command

modify user as account = ('<place_modified_account_string_here>');

and that should be all there is to it.

Bill Grenwelge
Wal-Mart Stores, Inc.



     
  <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: 27 Dec 2016