ORA-01031: insufficient privileges

[Former Member]

Hi All,

This is the issue i am facing in DB13.............

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

'PREPARE stmt_6 STATEMENT FROM'

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

ORA-01031: insufficient privileges

As per the Note:834917

i have checked the role is active. Oracle version is 10.2.0.2.0

SQL> select * from DBA_ROLE_PRIVS where granted_role = 'SAPCONN';

GRANTEE GRANTED_ROLE ADM DEF

-

---

-

---

--- ---

SAPRDC SAPCONN NO YES

SYS SAPCONN YES YES

Still i am unable to identify where the actual issue is and what the steps need to perform to resolve the issue. As it is a training system.

Plz help me...

Thanks

[Former Member]

Hi Sonu prasad,

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

and also try to (re)execute the sql script SAPDBA_ROLE.SQL ,You can find it on kernel directory

Please check the below mentioned forums:

please follow the above your problem will resolve.

Thanks

Kishore

[stefan_koehler]

Hello,

have you already checked sapnote #900525?

Regards

Stefan

[Former Member]

Hi,

Try

If you are on UNIX then

grant connect, resource, SAPDBA to OPS$ORASID with admin option;

OR On Windows

Try

grant connect, resource, SAPDBA to OPS$<Domain>SAPServiceSID with admin option;

check.

Thanks,

Shambo

Edited by: Shambo on Aug 6, 2008 6:34 AM

[Former Member]

Hi Shambo,

I have adjusted the Missing grants to tthe table as below....but still i see the error in db13

SQL> grant select on "SAPSID".DDART to DBL_R3DSTF;

Grant succeeded.

I have checked the role of the grantee as shown below

SQL> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'OPS$SIDADM';

GRANTED_ROLE

-

---

RESOURCE

CONNECT

SAPDBA

as we are on HP-UX

Please suggest me.....

Thanks.......

[Former Member]

Hi

SQL> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'OPS$SIDADM';

try below query,

SQL> grant connect, resource, SAPDBA,SAPCONN to OPS$ORASID with admin option;

SQL> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'OPS$ORASID';

SQL>Commit;

Lets try this & let me know