Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
How to view and edit workspace in Apex via SQL Developer?

Hello everybody!
I have Oracle Database 11g and Application Express 5 installed, I also have access to Apex through ORDS. How can I configure access to tables and others in the Apex workspace via SQL Developer?
How to create a connection correctly?
Answers
-
How can I configure access to tables and others in the Apex workspace
Your question is not clear. What problem are your trying to solve? Which tables? Give access to whom? Are you talking about tables in the APEX_5xxxx (whatever it is exactly) schema?
You have access to APEX data via published views and APIs.
How to create a connection correctly?
The APEX schema has public views and API's, so any user can use these. Many views and APIs only make sense in the context of an APEX session (because you need a sessionid).
-
Hi, InoL. Thank you for your attention to my question.
I am more of an expert in SQL-PL/SQL than in Oracle and APEX administration.
I have achieved the following:
1) I can connect with APEX_PUBLIC_USER / APEX_REST _PUBLIC_USER users,
2) in Other Users I see the administrator of the VRBC workspace (this is exactly what i need), but there it is almost empty (no tables, no views, no triggers, etc.).
The goal was to see everything the same as through SQL Workshop > Object Browser. Isn't that possible?
-
I can connect with APEX_PUBLIC_USER / APEX_REST _PUBLIC_USER users
Never login with APEX_PUBLIC_USER, APEX_REST _PUBLIC_USER or any other APEX user.
The goal was to see everything the same as through SQL Workshop > Object Browser. Isn't that possible?
Yes, login as the schema owner. If your VRBC workspace uses schema VRBS (for instance), login as user VRBC.