ORA-01031: insufficient privileges

[Former Member]

We are getting this alert during DB13 -Check DB

BR0301W SQL error -1031 at location rz20_info_save-1, SQL statement:

'PREPARE stmt_1 STATEMENT FROM'

'UPDATE "SAPDATDB"."SDBAD" SET LINE = :line WHERE BEG = :beg AND FUNCT = :funct AND POS = :pos'

ORA-01031: insufficient privileges

[Former Member · Accepted solution]

Hi,

Please execute the sql scripts(sapconn_role.sql, sapdba_role.sql) which are availale in kernel directory. copy the sql scripts from kernel directory to any oracle directory. switch to ora<sid> user and go to sql prompt and then execute the script.

Regards,

Sagar

[Former Member]

Read SAP Note 400241 (*nix) 50088 (Wintel).

Regards,

Nick Loy

[Former Member]

Hi

Try checking these notes may help you,

Nnote 175636 and 480266

Regards

Uday

[Former Member]

Hi,

A simple search in SDN/Service market place might help you.

Read Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

If you have upgraded any kernel consider running oracle scripts like sapdba_role.sql , sapconn_role.sql.

Regards,