Connection Issue - Can't create table
Posted: Wed 01 Aug 2018 13:54
Hey guys,
After successfully defining the connection and logging in I can use the software OK - do queries, browse data, etc.
However if I am trying to create a table using the wizard I get an "ORA-01031 insufficient privileges" error. If I copy the SQL created by the wizard in an SQL window, I get the same error.
If I paste the SQL in a Toad, same connection, same user, everything, the table gets created without any problem.
What is going on? How could I investigate this?
Thank you,
Marius
After successfully defining the connection and logging in I can use the software OK - do queries, browse data, etc.
However if I am trying to create a table using the wizard I get an "ORA-01031 insufficient privileges" error. If I copy the SQL created by the wizard in an SQL window, I get the same error.
If I paste the SQL in a Toad, same connection, same user, everything, the table gets created without any problem.
What is going on? How could I investigate this?
Thank you,
Marius