Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

DBA Dictionary Views

By default, SQL Navigator gives you USER object data dictionary views, meaning you can see only objects you own or for which you have been granted object privileges.

When you Enable DBA views in SQL Navigator you can...

Edit Profiles, Roles, and Users.

View the following nodes of the DB Navigator tree:

  • Roles
  • Some nodes under Users
  • Datafiles under Tablespaces
  • Redo Log Groups
  • Rollback Segments
  • Partitioned tables in another user’s schema

How to enable DBA views in SQL Navigator

Oracle Logon Dialog | Enable DBA Views

Oracle requirements to query DBA views

Your username must have one of the following roles or privileges:

  • DBA Role
  • SELECT_CATALOG_ROLE Role
  • SELECT ANY TABLE Privilege

DBA role and SELECT_CATALOG_ROLE role must be defined as the default roles in Oracle.

In addition to the SELECT ANY TABLE privilege, Oracle 9i may also require the user to have the SELECT ANY DICTIONARY privilege if the O7_DICTIONARY_ACCESSIBILITY initialization parameter is set to FALSE.

For information about system privileges, see the Oracle Database Administrator’s guide.

 

Note: Enabling DBA dictionary views may affect performance for some Oracle instances, depending on the number of users and objects, as well as other environmental factors.

 

How SQL Navigator handles the views

When DBA dictionary views are selected, SQL Navigator interrogates the data dictionary differently:

Regardless of DBA View setting, SQL Navigator uses USER_% views for the logged-on user's objects.

Without DBA Views, SQL Navigator uses ALL_% views for other user's objects.

With DBA Views, SQL Navigator uses SYS.DBA_% views for other user's objects.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating