I have a problem with with latest version of APEX, I have installed it on my pc, i logged in as and admin created workspace with schema, but when I log in to that workspace as a user with admin's privileges or developer's privileges and try to use SQL Workshop I get an error:

User <MyUserName> has no privileges on the schema. Contact your application administrator.

When I try create a table with SQL command I get

Schema "DB" does not exist in the database. Please contact your workspace admin to set correct default schema for you.

even though user has been assigned that schema and it does exist.

When I try to create another schema for the workspace I can't and I get an error

ORA-65096: invalid common user or role name

Even when I try create new workspace create workspace I get an error

Error provisioning <workspaceName>. ORA-20001: Request 1246482779115523 could not be processed. PROVISION_COMPANY

but when I press return and press create workspace again it succeeds for some reason.

I have no idea what to do, how to solve this problem, I tried everything in settings: granting privileges, setting default schemas, creating new users, setting role as developers, yet the issues do not go away. Any help is appreciated.

| improve this question | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.