ORA-01031 when creating a view

[Former Member]

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]

THe system details

SAP R/3 4.7

DB 10.2.0.4

OS win 32 enterprise edition

[Former Member]

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]

I have sysdba authorization for SAPR3 and OPS$PRDADM.

do i need to give the SAPCONN

[Former Member]

Hi Rabi,

Try it and check it may work fine.

Regards

Ashok

[Former Member]

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]

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

it went fine...