Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 01 May 2003 @ 16:03:39 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Profiles
From:   Crisafulli, Ronald

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
no fallback

Ron Crisafulli

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020