Sunday, April 30, 2017

ORA-01031:'SELECT MAX(SYSTEMNAME), MAX(SYSID) FROM SAP_MLICHECK WHERE EXPIRATION_DATE = (SELECT MAX(EXPIRATION_DATE) FROM SAP_MLICHECK)'



BR0280I BRBACKUP time stamp: 2010-02-16 09.32.04

BR0301E SQL error -1031 at location BrLicCheck-12, SQL statement:

'SELECT MAX(SYSTEMNAME), MAX(SYSID) FROM SAP_MLICHECK WHERE EXPIRATION_DATE = (SELECT MAX(EXPIRATION_DATE) FROM SAP_MLICHECK)'

ORA-01031: insufficient privileges


And it's fixed by running below SQL statement.

grant select,update on <SCHEMA>.MLICHECK to OPS$ORA<SID>;

1 comment: