How to provide Data Dictionary access to SQL Developer users without granting the DBA role
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.
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)
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