AnaIsabelFlor77
Programmer
Hello,
I have a table that defines wich person is using a DB user at a time:
DB_USER ID_NAME LOGIN LOGOFF
USER1 Ana 27-10-2012 18:10:05 27-10-2012 18:18:05
USER1 John 27-10-2012 18:18:06 27-10-2012 18:28:05
USER1 Greg 27-10-2012 18:20:09 27-10-2012 18:25:05
How can I find out if more than one person was using the same DB user at that interval of time? I know that in this example it should return the following:
DB_USER ID_NAME Date
USER1 John 27-10-2012
USER1 Greg 27-10-2012
Can you help me?
Thanks
I have a table that defines wich person is using a DB user at a time:
DB_USER ID_NAME LOGIN LOGOFF
USER1 Ana 27-10-2012 18:10:05 27-10-2012 18:18:05
USER1 John 27-10-2012 18:18:06 27-10-2012 18:28:05
USER1 Greg 27-10-2012 18:20:09 27-10-2012 18:25:05
How can I find out if more than one person was using the same DB user at that interval of time? I know that in this example it should return the following:
DB_USER ID_NAME Date
USER1 John 27-10-2012
USER1 Greg 27-10-2012
Can you help me?
Thanks