I have an Exception Type Rule in my Policy where the Exception Type field of the criteria of the rule is SQL_ERROR and Error Code addressed to Failed_Error_Code Group, i.e I have in this group different error_codes members from ORACLE and DB2 like these: ORA-01045, ORA-01031, (DB2) SQL0103N and others. So I executed the commands on the DBServer (ORACLE,DB2) to get the Error_Codes, like this:
ORA-01045: user PERRITA lacks CREATE SESSION privilege; logon denied
PERRO@faxflow>create user PERRITA identified by Lserdt99;
create user PERRITA identified by Lserdt99
ERROR at line 1:
ORA-01031: insufficient privileges
mxemch010503ads:db2admrt:/db2/db2admrt $ db2 select * from TW1_CAMPANIALEAP_D
SQL0103N The numeric literal "1crmrt_campanialeap_d" is not valid.
But when I run my Report within Guardium it just obtains the ORA-01045 in the Error Code Colum an their description in the Database Error Text Column and the others ErrorCodes I do not catch them. Do you know what is the reason? Why do not I catch the others ErrorCodes?
|user string lacks CREATE SESSION privilege; logon denied||Database Error Text|
The inspection Engine is working in the Databases and the STAP too in the DBServers
Thanks in advance!