I am wanting to use the API : apex_instance_admin.add_workspace to create a workspace.
When I run the API I get an error message :
ORA-20987: User requires ADMIN privilege to perform this operation
My question, which database user do I use that has the privledges to use this API ?
Could you please explain how you like use that API ?
From default users e.g. SYS can execute apex_instance_admin package.
You can grant APEX_ADMINISTRATOR_ROLE to user(s) and then they can execute apex_instance_admin package.