Archives of the TeradataForum

Message Posted: Wed, 15 Nov 2006 @ 20:13:42 GMT

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

<-- Anonymously Posted: Wednesday, November 15, 2006 15:10 -->

Hello,

In our some of application jobs we need to use different account id/string for user id's.

I have modified user to take additional 2 new accounts id's. But when I am using new Account at the time of LOGIN, it is not taking new account. I am getting error as "*** Error: Logon failed!".

As per document "Database Administration" Page 128. "Each time a CREATE/MODIFY USER/PROFILE statement is processed, a row is inserted or updated in DBC.Accounts and DBC.DBase or DBC.Profiles."

After modifying UserID I checked DBC.Accounts and DBC.Dbase tables. I noticed that new accounts are inserted only in DBC.Accounts and NOT in DBC.Dbase. We can use different accounts only if DBC.Users view has that specified account in "DefaultAccount" field. This DefaultAccount field gets value from "Dbase.AccountName". As DBC.Dbase is not getting updated Accounts, I am not able to use it. DBC.Dbase has only one account, which was assigned during user creation.

When I tried to use SET SESSION ACCOUNT it is giving me syntax error like below.

     SET SESSION ACCOUNT-'$M1$&D&H&S';
     +---------+---------+---------+---------+---------+---------+
     SET SESSION ACCOUNT-'$&D&H&S';
      *** Failure 3707 Syntax error, expected something like a string between
     a string and ';'.
                     Statement# 1, Info -32
      *** Total elapsed time was 1 second.
     +---------+---------+---------+---------+---------+---------+

Can anybody tell me what going wrong in this case? To use different accounts and SET SESSION ACCOUNT, do we need to setup any DBC Control parameter? Anybody has experienced this in their system?

Thanks

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