Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Changing logon strings
From:   Bill Grenwelge


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