Description of problem: <pjones> can you do me a favor and file a bug asking for exec on rhn_exception to be granted to web_dml_r ? <pjones> (just because the dbchange system requires a bug ID...)
also need the following added to the rhn_exception tables for this to work: label, msg webreg_duplicate, Registration number already registered webreg_not_active, Registration number is not active webreg_sync_error, Synchronization error with sync_registration_uber webreg_invalid, Registration number is invalid webreg_unknown_error, Unknown registration error
according to pjones, ON_DEV. Test Plan: will be tested by successful runs of bz #128392 and #128396
Not done: rhnuser@webdev> select web.web_api.register_product('fd78-b3a5-2489-87bf', 37586 08) from dual; ORA-20001: Unable to lookup exception with label (webreg_invalid) ORA-06512: at "RHN.RHN_EXCEPTION", line 31 ORA-06512: at "WEB.WEB_API", line 70
rhnuser@webdev> select id, label from rhnexception where label like 'web%'; 0 rows selected (0.01 seconds) So, we're missing all of these.
Exceptions are on dev now, sorry.
Looks good on Dev
Looks good on QA.