Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-01031 when creating a view

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
Not what you were looking for? View more on this topic or Ask a question