Archives of the TeradataForum
Message Posted: Fri, 11 Aug 2000 @ 09:06:50 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|