Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-01031: insufficient privileges : DB13 CheckDB error

Hi All,

I am getting below error in DB13- checkDB.

I have run the sapdba_role but same error.

BR0280I BRCONNECT time stamp: 2009-09-15 06.30.08

BR0818I Number of tables found in DBDIFF for owner SAPR3: 2

BR0280I BRCONNECT time stamp: 2009-09-15 06.30.08

BR0301E SQL error -1031 at location BrDdartRead-1, SQL statement:

'PREPARE stmt_6 STATEMENT FROM'

'SELECT TABART FROM "SAPR3".DDART ORDER BY TABART'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: ceblwauo.chk 2009-09-15 06.30.08

BR0280I BRCONNECT time stamp: 2009-09-15 06.30.08

BR0804I BRCONNECT terminated with errors

Sap: 45B

oracle: 9.2

Thanks in advance.

Vinod

Former Member
replied

This should fix your error:

sqlplus "/ as sysdba"

grant SELECT on SAPR3.DDART to sapdba;

exit

if it still fails later, also add these:

Sqlplus "/ as sysdba"

grant ALL on SAPR3.SDBAH to sapdba;

grant ALL on SAPR3.SDBAD to sapdba;

grant ALL on SAPR3.DBAML to sapdba;

grant ALL on SAPR3.DBARCL to sapdba;

grant ALL on SAPR3.DBAFID to sapdba;

grant ALL on SAPR3.DBAEXTL to sapdba;

grant ALL on SAPR3.DBAREOL to sapdba;

grant ALL on SAPR3.DBABARL to sapdba;

grant ALL on SAPR3.DBADFL to sapdba;

grant ALL on SAPR3.DBAOPTL to sapdba;

grant ALL on SAPR3.DBASPAL to sapdba;

grant ALL on SAPR3.DBABD to sapdba;

grant ALL on SAPR3.DBABL to sapdba;

grant ALL on SAPR3.DBATL to sapdba;

grant ALL on SAPR3.DBAOBJL to sapdba;

grant ALL on SAPR3.DBAPHAL to sapdba;

grant ALL on SAPR3.DBAGRP to sapdba;

grant ALL on SAPR3.DBAERR to sapdba;

grant ALL on SAPR3.DBATRIAL to sapdba;

grant ALL on SAPR3.DBSTATC to sapdba;

grant ALL on SAPR3.DBSTATTORA to sapdba;

grant ALL on SAPR3.DBSTATIORA to sapdba;

grant ALL on SAPR3.DBSTATHORA to sapdba;

grant ALL on SAPR3.DBSTAIHORA to sapdba;

grant ALL on SAPR3.DBMSGORA to sapdba;

grant ALL on SAPR3.DBCHECKORA to sapdba;

grant ALL on SAPR3.MLICHECK to sapdba;

grant SELECT on SAPR3.TGORA to sapdba;

grant SELECT on SAPR3.IGORA to sapdba;

grant SELECT on SAPR3.TSORA to sapdba;

grant SELECT on SAPR3.TAORA to sapdba;

grant SELECT on SAPR3.IAORA to sapdba;

grant SELECT on SAPR3.SVERS to sapdba;

grant SELECT on SAPR3.CVERS to sapdba;

grant SELECT on SAPR3.DD02L to sapdba;

grant SELECT on SAPR3.DD09L to sapdba;

grant SELECT on SAPR3.DDNTT to sapdba;

grant SELECT on SAPR3.DDART to sapdba;

grant SELECT on SAPR3.DARTT to sapdba;

grant SELECT on SAPR3.DBCHK to sapdba;

grant SELECT on SAPR3.DBDIFF to sapdba;

grant ALL on SAPR3.SAPLIKEY to sapdba;

grant SELECT on SAPR3.RSNSPACE to sapdba;

grant SELECT on SAPR3.RSPSPACE to sapdba;

exit;

good luck.

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question