How to solve problem when oracle apex does not let me do anything with my created schemas even though I should have privileges?
2
votes
0
answers
2301
views
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 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 .
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.
Asked by David
(21 rep)
May 26, 2019, 09:13 AM
Last activity: May 27, 2019, 03:06 PM
Last activity: May 27, 2019, 03:06 PM