Archives of the TeradataForum

Message Posted: Thu, 01 Nov 2007 @ 20:51:38 GMT

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

<-- Anonymously Posted: Thu, 1 Nov 2007 15:49 -->

     MODIFY USER x AS DEFAULT DATABASE = y ;

Each time "x" logs on, the initial default database will be "y" (but could be changed by a subsequent "DATABASE z;" statement).

In Teradata, you can't change the Username (or contents of the USER variable) after logon. In a more limited way, you can execute requests (e.g. via stored procedure) that use the authority of a user other than the current one.

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