OracleMetadataProvider uses USER_* views while legacy OracleSchemaManager uses ALL_* views, causing introspectTableByUnquotedName() to fail when session user ≠ schema owner

[k0n3r]

Bug Report

Q	A
Version	4.4.1
Previous Version if the bug is a regression	N/A

Summary

Inconsistent behavior between deprecated SchemaManager API and the new
introspectTableByUnquotedName() when Oracle session user differs from schema owner.

Current behavior

introspectTableByUnquotedName() queries USER_* views and fails with
TableDoesNotExist when session user ≠ schema owner.

Steps to reproduce

1. Oracle DB with schema owner user SCHEMA_OWNER.
2. Connect DBAL with a different session user (e.g., DBA proxy or application user) that has privileges on SCHEMA_OWNER's tables, with dbname = 'SCHEMA_OWNER'.
3. Call $schemaManager->tablesExist(['my_table']) → returns true (uses ALL_TABLES WHERE OWNER = 'SCHEMA_OWNER').
4. Call $schemaManager->introspectTableByUnquotedName('my_table') → throws TableDoesNotExist (uses USER_TAB_COLUMNS which only sees the session user's own tables)

Expected behavior

Should use ALL_* views scoped by OWNER, consistent with tablesExist() and
introspectTable().

[morozov]

@k0n3r could you provide some specific SQL statements to configure the database as described?

While I was implementing the new API, my assumption was that the current schema corresponds to the name of the user used in the connection:

dbal/src/Platforms/OraclePlatform.php

Lines 120 to 123 in 9a2121a

	public function getCurrentDatabaseExpression(): string
	{
	return "SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')";
	}

So querying the ALL_* views filtered by the owner being the current user should be the same as querying the USER_* views.

[k0n3r]

After more investigation I realized that in my specific setup the session user and the schema owner are the same, so the USER_* vs ALL_* inconsistency described here doesn't
directly cause the failure I was seeing.

The actual root cause in my case was different: with UnquotedIdentifierFolding::LOWER configured on the platform, introspectTableByUnquotedName('migrations') passes the table
name as lowercase 'migrations' to WHERE TABLE_NAME = :TABLE_NAME, but Oracle's data dictionary stores all unquoted identifiers as uppercase MIGRATIONS — so the query returns
nothing. Meanwhile tablesExist() still returns true because it lowercases both sides before comparing (AbstractSchemaManager line 184), creating the same false-positive symptom.
I've opened a separate issue covering that: #7330.

That said, this issue is still valid on its own — the USER_* vs ALL_* inconsistency is a real problem for setups where the session user differs from the schema owner and should
be fixed independently.

[morozov]

That said, this issue is still valid on its own

I'm fine with making the new code use the ALL_* views instead of the USER_*. But I need to understand the configuration that leads to the problem first.