ORA-01031 when creating a view
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.
Thanks and regards,