Table Privileges and access
Posted on 2006-05-17
I have two environments, test and production, both environments were created from an existing production database using export and import.
database version is oracle 8.1.7
access for the users is through Oracle Discoverer.
One of the Discoverer business areas contains folders looking at the DBA_ROLE_PRIVS, DBA_USERS and DBA_ROLES views.
From the test environment this works fine and the user is able to run queries against those views.
In the production environment, although the business area is available, there are no folders for selection.
The underlying privileges for the user appear to be exactly the same in both environments.
If I log in via TOAD as the user to the test environment and run the query 'select * from dba_users', then data is returned, however the same query in the production environment gives the 'Table or view does not exist' error.
Having checked all the dba_tab_privs, user_role_privs views etc, there doesn't appear to any anomalies between the two databases, therefore what could be preventing access to these views in the Production environment?