User DDL detail by Session
From:
2013/01/15 04:00:00
To:
2013/01/16 04:00:00
AIX-11g
ORA11 on lpar26p682e_pub
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000159TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1002
2013/01/15 12:43:59CREATE USERcreate user dummy identified by                   
2013/01/15 12:44:27DROP USERdrop user dummy
000270TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1002
2013/01/15 17:05:14GRANT OBJECTgrant select any table to tom
2013/01/15 17:05:15REVOKE OBJECTrevoke select any table from tom
000279TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1002
2013/01/15 17:24:53GRANT OBJECTgrant select any table to tom
2013/01/15 17:24:54REVOKE OBJECTrevoke select any table from tom
000287TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1002
2013/01/15 17:39:06GRANT OBJECTgrant insert any table to hrapp
2013/01/15 17:40:06REVOKE OBJECTrevoke insert any table from hrapp
000292TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1002
2013/01/15 17:47:11CREATE USERcreate user dummy identified by                   
2013/01/15 17:47:37DROP USERdrop user dummy
Linux32-10g
ORA10 on centos32
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000425TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 12:54:26INTERNALcreate user dummy identified by                   
2013/01/15 12:54:57INTERNALdrop user dummy
000575TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:06:18GRANT OBJECTgrant select any table to tom
2013/01/15 17:06:19REVOKE OBJECTrevoke select any table from tom
000583TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:25:48GRANT OBJECTgrant select any table to tom
2013/01/15 17:25:49REVOKE OBJECTrevoke select any table from tom
000591TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:42:17GRANT OBJECTgrant insert any table to hrapp
2013/01/15 17:43:17REVOKE OBJECTrevoke insert any table from hrapp
000595TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:50:13INTERNALcreate user dummy identified by                   
2013/01/15 17:50:27INTERNALdrop user dummy
Linux64-11g
ORA11 on centos64
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000991TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 13:02:24CREATE USERcreate user dummy identified by                   
2013/01/15 13:03:36DROP USERdrop user dummy
001618TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:06:54GRANT OBJECTgrant select any table to tom
2013/01/15 17:06:55REVOKE OBJECTrevoke select any table from tom
001664TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:26:12GRANT OBJECTgrant select any table to tom
2013/01/15 17:26:13REVOKE OBJECTrevoke select any table from tom
001708TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:43:42GRANT OBJECTgrant insert any table to ccapp
2013/01/15 17:44:42REVOKE OBJECTrevoke insert any table from ccapp
Solaris-10g
ORA10 on steel
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000464TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 12:40:08INTERNALcreate user dummy identified by                   
2013/01/15 12:40:35INTERNALdrop user dummy
000834TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:11:48GRANT OBJECTgrant select any table to tom
2013/01/15 17:11:48REVOKE OBJECTrevoke select any table from tom
000864TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:31:02GRANT OBJECTgrant select any table to tom
2013/01/15 17:31:03REVOKE OBJECTrevoke select any table from tom
000889TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:50:12GRANT OBJECTgrant insert any table to ccapp
2013/01/15 17:51:13REVOKE OBJECTrevoke insert any table from ccapp
000894TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:53:57INTERNALcreate user dummy identified by                   
2013/01/15 17:54:18INTERNALdrop user dummy
Windows-11g
ORA11 on bluecore2
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
001610TOMsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 12:16:23CREATE USERcreate user dummy identified by                   
2013/01/15 12:17:02DROP USERdrop user dummy
002092TOMsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 17:05:48GRANT OBJECTgrant select any table to tom
2013/01/15 17:05:49REVOKE OBJECTrevoke select any table from tom
002110TOMsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 17:15:41GRANT OBJECTgrant select any table to tom
2013/01/15 17:15:42REVOKE OBJECTrevoke select any table from tom
002115TOMsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 17:17:44GRANT OBJECTgrant select any table to tom
2013/01/15 17:23:31REVOKE OBJECTrevoke select any table from tom
002131HRAPPsqlplus.exeWORKGROUP\BLUECORE23
2013/01/15 17:34:11ERRORgrant insert any table to hrapp
2013/01/15 17:34:46ERRORgrant insert into mycopy to hrapp
2013/01/15 17:35:57ERRORgrant insert on mycopy to hrapp
002144TOMsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 17:38:15GRANT OBJECTgrant insert any table to hrapp
2013/01/15 17:39:15REVOKE OBJECTrevoke insert any table from hrapp
002163TOMsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 17:46:47CREATE USERcreate user dummy identified by                   
2013/01/15 17:47:05DROP USERdrop user dummy