cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01031: insufficient privileges

Former Member
0 Kudos

Hi there,

I am trying to run brconnect stats and I get this error in SQL Query. Can you please tell me how to change the permission on the oracle side



BR0301W SQL error -1031 at location brc_dblog_write-5, SQL statement:
'INSERT INTO SAP_SDBAD (BEG, FUNCT, POS, LINE) VALUES ('20070912103654', 'sta', '0000', 'A 0000000000000000 00000000 00000000 0
ORA-01031: insufficient privileges
BR0325W Writing to database log failed
BR0280I BRCONNECT time stamp: 2007-09-12 10.38.21
BR0301W SQL error -1031 at location brc_dblog_open-1, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20070912103654', 'sta', 'PR2', 'ALL', '9999', '
ORA-01031: insufficient privileges
BR0324W Insertion of database log header failed

BR0806I End of BRCONNECT processing: cdwdgbnq.sta2007-09-12 10.38.20
BR0280I BRCONNECT time stamp: 2007-09-12 10.38.21
BR0803I BRCONNECT completed successfully with warnings
External program terminated with exit code 1
BRCONNECT returned error status E
Job finished


Thanks in Advance

Kumar

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hello,

SAP_SDBAD is a synonymous. Please check to which table is pointing.

That is the table you do not have authorizations. Please check table and owner.

Now, you mentioned that this is a system copy.

Regarding SAPDBA_ROLE,as mentioned on the note 134592:

<i>Oracle 9.2: sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

Oracle 10g: sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

Where <SAPSCHEMA_ID> is the schema ID of the SAP database user:

- for User SAPR3: R3

- for User SAP<SID>: <SID>

- for User SAP<SID>DB: <SID>DB

The log file sapdba_role.log is created in the current directory. </i>

But the error you mention is not related to passwords.

You do not <i>need</i> to change teh password after refresh, but you will have the password from your original system, if you are "aware" of that, then no problem.

<i><b>what does external means?</b></i>

it means that the two users do not need a password to connect to the database as they are authentificated by the OS ( ifall other configuration is correct ) you can check notes

562863 FAQ: Logon mechanisms

700548 FAQ: Oracle authorizations

Hope it helps

Former Member
0 Kudos

proble resolved after I ran this script again

sqlplus /nolog @sapdba_role R3

Former Member
0 Kudos

Two things:

Make sure that you have run the sapdba_role script or sapconnect script if you are in Oracle 10

As orasid from /sapmnt/SID/exe run , say that your SID is PRD

sqlplus "/ as sysdba" @sapdba_role PRD

and/or

Run the saproot.sh script as root from /sapmnt/SID/exe

./saproot.sh PRD

This will make sure that your brtools have the correct ownership and permissions

Let me know how you get on .

If not solved, tell us OS you are running on, database and brtools version

Andreas

Former Member
0 Kudos

Thansk for quick reponse.

I forgot to mention that this system is database referesh of our Production system .

I did run this command at the end:

sqlplus /NOLOG @sapdba_role R3

you're telling to run this

sqlplus "/ as sysdba" @sapdba_role PRD

Do I put the SID or R3?

Note as per note: 361461

I ran this script first:

sqlplus /NOLOG @oradbusr. sql SAPR3 UNIX PR2 x

after that I ran

sqlplus /NOLOG @sapdba_role R3

thats about it:

I NEVER change or set the SAPR3 user password as on the note: 361641

[code]

The SCHEMAOWNER is either SAPR3 or has to start with SAP followed by the three digit schema id (example: SAPPRD).

On Unix x is a dummy parameter and may e. g. be set to X.

To change the password for the SAPR3 or SAP<SID> user you have to use the following command:

brconnect -u system/<syst_pwd> -f chpass -o SAPR3 -p <new_sap_pwd>

or

brconnect -u system/<syst_pwd> -f chpass -o sap< sid> -p <new_sap_pwd>

Do I need chaneg the password after refresh?

I am using SunOS 5.8, Oracle 10g, SAP ECC 5.0.

User name in SQL:

SQL> select username , password from dba_users;

USERNAME PASSWORD

-


-


OPS$PR2ADM EXTERNAL

OPS$ORAPR2 EXTERNAL

what does external means?

former_member204746
Active Contributor
0 Kudos

try this:

sqlplus / as sysdba

grant all on sapr3.SAP_SDBAD;

grant all on sapr3.SAP_SDBAD;

Former Member
0 Kudos

SQL> grant ALL on SAPR3.SAP_SDBAD;

grant ALL on SAPR3.SAP_SDBAD

*

ERROR at line 1:

ORA-00905: missing keyword

former_member204746
Active Contributor
0 Kudos

try these:

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.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;

Message was edited by:

Eric Brunelle