Sysdba login - find details

Database
Enthusiast

Sysdba login - find details

Hi,

We have 4-5 people as DBAs. we login with a default id of sysdba. I want to know the individual name , terminal details etc from where one is logging using the common id sysdba.

Is there a dbc table/query to find that

Samir

1 REPLY
Junior Contributor

Re: Sysdba login - find details

Hi Samir,

dbc.LogonOffV holds the history of logons/logoffs and there's a column named LogonSource, which includes the network username.

The same column is in dbc.QryLogV, but it's also split into AppId, ClientId and ClientAddr.

Dieter