Question Re: ORA-01031 when creating a view in Technology Q&A

ORA-01031 when creating a view

Former Member — Wed, 17 Sep 2008 10:20:39 GMT

Hi guys,

I transported a view(custom view ZVIEW) from Development to Production and found that the view was missing the database of the production system.

When i tried to create the same view usin SE14 am getting a warning

ORA-01031: insufficient privileges

DDL time(___1): .......119 milliseconds

The SQL statement was not executed

Statements for View ZVIEW_STD_TIME could not be executed

Request for ZVIEW_STD_TIME could not be executed

in the system the SAPR3 and OPS$PRDADM has sysdba privilege so i guess SYSCONN need not be implemented.

Please help.

Thanks and regards,

Siddhartha

Former Member — Wed, 17 Sep 2008 10:21:30 GMT

THe system details

SAP R/3 4.7

DB 10.2.0.4

OS win 32 enterprise edition

Former Member — Wed, 17 Sep 2008 10:43:55 GMT

Hi Rabi,

Check below sap notes.

Note 985607 - ORA-01031 Creating views after upgrade to Oracle 10g

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

Regards

Ashok

Former Member — Wed, 17 Sep 2008 11:00:44 GMT

I have sysdba authorization for SAPR3 and OPS$PRDADM.

do i need to give the SAPCONN

Former Member — Wed, 17 Sep 2008 11:13:14 GMT

Hi Rabi,

Try it and check it may work fine.

Regards

Ashok

Former Member — Wed, 17 Sep 2008 11:34:14 GMT

I have given CREATE VIEW privilege to SAPR3 and OPS$PRDADM.

Let me check after i restart the database as i will get the downtime tonight.

Former Member — Wed, 17 Sep 2008 12:10:49 GMT

I jus gave create view privilege to SAPR3 and tried..

it went fine...