Sunday, April 30, 2017

ORA-01031:'SELECT TABART FROM "SAPR3".DDART ORDER BY TABART'



If you are getting below error in DB13- checkDB.

BR0280I BRCONNECT time stamp: XXXXXXXXXX

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

BR0280I BRCONNECT time stamp: XXXXXXXXXX

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: XXXXXXXXXXXXX

BR0280I BRCONNECT time stamp: XXXXXXXXXXXXX


You need to run the sapdba_role.sql to fix this issue:

Go under /usr/sap/SID/SYS/run/exe and run

sqlplus /nolog @sapdba_role.sql SR3 <SID>- -- For ABAP sceham

sqlplus /nolog @sapdba_role.sql SR3<SID>DB- - -For Java Schema


Note:but it´s very important check if the script sapdba_role.sql is up to date to last version ....In some-case it worked only when download the last version  of this script



Also check the below sap notes if issue is not resolved, which will help you to resolve.

91216 - BRBACKUP-SAPDBA ORA-01031 Insufficient privileges

126248 - SAPDBA Check causes ora-01031

761745 - Oracle 9 ORA-01031 and ORA-06512 with DBMS_STATS

900525 - BRCONNECT fails with ORA-01031 at location BrDdartRead-1

1028220 - ORA-01031 Insufficient privileges despite SAPCONN role

834917 - Oracle Database 10g New database role SAPCONN

134592 - Importing the SAPDBA role (sapdba_role.sql)

In case insufficient privileges issue to" DDART" table after given permission like below issue will be resolved.

grant SELECT on SAPR3.DDART to sapdba;



1 comment: