Specifying Oracle Views Configuration When Registering Datasources

Go Up to Manually Registering or Editing Datasources

The Datasource Registration Wizard’s Oracle View Config panel lets you manually configure access to Oracle Data Dictionary DBA or ALL/USER views to conform to the view privileges associated with a specific role.

Note: In order to enable manual configuration of Oracle Data Dictionary views for Oracle datasources and make this panel available, you must select Use Datasource Configuration for Views in the Options Editor (File > Options > General > Oracle). For more information, see General Options.

Only DBA views with an ALL/USER equivalent are offered on this panel. You can use the following methods to select DBA or ALL/USER type views on a view-by-view basis:

Option	Description
Manual selection using the Use DBA View check boxes	Selecting the Use DBA View check box associated with an individual view makes the DBA group version of that view available. Deselecting the Use DBA View check box associated with an individual view makes the ALL/USER group version of that view available.
Reset to All	Deselects all Use DBA View check boxes, making only ALL views accessible.
Reset to DBA	Selects all Use DBA View check boxes, making DBA views accessible.
Resolve Automatically (only available when editing a connected datasource)	Queries the datasource and selects the Use DBA View check box for each DBA view to which the current user has access.

Changes take effect as soon as you click the Finish button.

For more general information on registering datasources, see Manually Registering or Editing Datasources.