MCP Server for Oracle

Build 25.0.9440

UseDBAMetadataViews

Specifies whether to obtain metadata from system views prefixed with 'ALL' or those prefixed with 'DBA'.

Data Type

bool

Default Value

false

Remarks

When this connection property is set to False (the default), the server queries system views whose names start with "ALL" to retrieve metadata for the objects accessible to the current user. These system views only return metadata for server objects the authenticated user has sufficient privileges to access.

When this connection property is set to True, the server instead queries system views whose names start with "DBA" to obtain metadata. These system views provide metadata for all of the Oracle OCI objects in the database, but this option will not work if the current user has insufficient privileges to access "DBA_.." system views.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440