The "Check Syntax" process in APEX, typically used in SQL Workshop or when validating code, authenticates usingDatabase schema credentials. These are the credentials of the schema associated with the APEX workspace (e.g., username/password of the schema like "HR"). This ensures the process has access to parse and validate SQL or PL/SQL against the database objects in that schema.
APEX Workspace Admin credentials: These are for managing workspaces, not executing database-level syntax checks.
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit