Teradata get logged in user details easily

Teradata has some great inbuilt functions to help to collect the basic details of the user. It has functions to identify who is the current logged in user, what is the role associated with the user in the system

Logged in user-id

SELECT CURRENT_USER;

The above command will give the ID of the currently logged in user

Current user’s role

SELECT ROLE;

The above command will give the role associated with the logged-in user

Current user’s profile

SELECT PROFILE;

The above command will give the Teradata profile of the user

Also read,

1. Teradata get current date and time
2. Creating tables with examples
3. Create tables using Select in Teradata
4. Teradata BTEQ to export table to file