How to provide Data Dictionary access to SQL Developer users without granting the DBA role (Doc ID 1274851.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 1.5.4 and later
Information in this document applies to any platform.
Checked for relevance on 28-Jan-2014

This note is intended for SQL Developer users and Database Administrators who wish to give developers the ability to use SQL Developer's data dictionary-based functionality without granting the DBA role.


Goal

It is common for database administrators to restrict the granting of the DBA role.  However, there are several features in SQL Developer that require user access to the Oracle database's data dictionaries, which is easily provided through the DBA role.  Features requiring data dictionary access include:

  • Running Data Dictionary Reports
  • Browsing objects in the Connections navigator (especially under the Other Users nodes)
  • DBA Navigator (3.0 and higher)

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms