Archives of the TeradataForum

Message Posted: Tue, 22 Jul 2003 @ 14:22:38 GMT

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

The problem here is that current versions of Teradata Administrator specify too many fields in a Modify User statement. (Fixed in the next release.)

If you use 'Preview mode' so that it displays the DDL before it submits it (You can press F4 to get to the options screen to change the mode) you can delete the following phrases (if they exist):

ACCOUNT = ('xxxx')
PROFILE = xxxx

and it will then work. (You can of course delete all the phrases where the values have not changed.)

Mike Dempsey
Teradata Client Tools

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