Is there any equivalent of sys_context (oracles function) in Teradata ?
sys_context( namespace, parameter, [ length ] )
What specific parameter are you interested in?
Basic info is returned by some built-in functions:
USER, DATABASE, ROLE, SESSION
See the list in the "SQL Functions and Operators" manual.