Archives of the TeradataForum
Message Posted: Thu, 01 May 2003 @ 16:03:39 GMT
We are in the process of pulling a part of a Tdat system out of a current environment and putting in down into its own new environment. Part of this process will involve recreating all the users & passwords as well as granting access rights. I constructed a query using DBASE & USERDB to formulate a CREATE USER statement and then I worked on the encrypted passwords separately. My question centers around understanding the ACCOUNT NAME . As you can see in this example below the account is defined with a value of $LNYDSS$DSS&D&T.
I believe the $LNYDSS$DSS are Profiles. The &D&T are just to incorporate date and time. What I'm trying to fine is a way to view the contents of the Profiles. I've tried to look for a table DBC.Profiles but have been unable to find it( may be in V2R5 & I'm running V2R4). Any suggestions on how to see what lies beneath.
create user XYZ
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|