Could you please let me know the query/process to find database name using Proxy id/Service id.
I t would be highly appreciated.
Silence might be related to the fact of unclear understanding of requirements.
What are you looking for?
"database name using Proxy id/Service id"???????????
In teradata View pont by having session id/username we can find out long running jobs/scripts.
I have two questions.
1.There is only one proxy id/username for every database?
2.If i want to find database name using proxy id/username,then what is the process to find out.
Please let me if you need furthe details.Thanks for reply
Please try the below query .......
FROM Dbc.Sessioninfo where username='USR_NAME' ;
Hi Koti.Thanks for reply.
Above Query Valid for username.
if i use Proxy id, do we have any query to find out name of the database?