 |
 |
Archives of the TeradataForum
Message Posted: Sun, 29 Oct 2006 @ 08:32:48 GMT
| Subj: | | Re: What is difference between AccountName and Account |
| |
| From: | | Geoffrey Rommel |
| | In account string we are defining priority (L, M, H, L1, M1 etc.). We can see this account string is getting used in DBC.QryLog,
DBC.AmpUsage as well as in DBC.Acctg. | |
| | But when I query against DBC.Databases it's showing me different account string under field "AccountName". | |
Very briefly, what's in DBC.Databases (or Dbase) is the default account string for the user. The user could have additional account strings,
which can be seen in AccountInfo. These strings are not expanded; that is, they probably contain variable names such as &L, &S, etc., which are
expanded during the session and go into QryLogTbl, etc. For more info, see the Database Administration manual.
It is also possible for the DBA to change the account string on the fly through PMon, but that's relatively rare.
| |
