Global temporary table access

HI team,
I am creating one global temporary table in my session. I have logged into teradata using my login credentials. I think this is one session. I insert some data into my table. Can I ask my friend to fetch data from this table after he logs into teradata using his credentials.

Once you login data you inserted will be specific to your session , no
other can see that , for other person this table is still empty
I ask my friend to login
1) Login
2) INsert 2 more rows with UID 1 and 4
3) Logoff

Your friend can insert data and select data whichever she has entered

Q1) But Priya said, my friend will not be able to fetch data. Will my friend
be able to insert data?
Your friend will not be able to fetch data you inserted as it will be
specific to your session only

Q2) Saubrah said, my friend will be creating new session if he logs in. Then
what all statements (DDL,DML,DCL) can he use on the GTT?
She can use either of the statements , provided she has access to that GTT
table.

As per Teradata, the GTT is specific to Session.
The definition can be used by different sessions.

Let us say, Priya created a Global Temporary Table.
She inserts 10 Records into this table.
Now Priya does issues a query:

" SELECT * FROM PRIYA.GTTBL; "

She will be able to see the 10 Records.

Now Sharadha wanted to see these 10 records which PRIYA inserted. This is impossible. These records are specific to this session only.
But Sharadha can be able to use query on "PRIYA.GTTBL", provided Sharadha has necessary access to this "GTTBL".
Sharadha can Select, Insert, Delete, Update this table. But these records will be visible to Sharadha only. Not to other sessions.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.