Oracle Data 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.

You can enable DBA dictionary views for a current session in Session preferences if you want to see all objects available under your DBA user privileges. DBA dictionary views are required for editing Profiles, Roles, and Users, or for viewing the following nodes of the DB Navigator tree:

 Roles

 some nodes under Users

 Datafiles under Tablespaces

 Redo Log Groups

 Rollback Segments

Required privileges

For access to DBA dictionary views, a user must have one of the following roles or privileges:

 DBA Role

 SELECT CATALOG Role

 SELECT ANY TABLE Privilege

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.