One of our developers uses PL/SQL Developer. He was connecting as a user granted DBA role which he should not have had. I have taken this role away from him but he now complains that he cannot see the access rights granted on objects. I am unfamiliar with the product as he is on a remote site. What access rights / privileges do Developers require to use this product fully.
Privileges required to see access on a table
- Thread starter richak
- Start date
There are no specific roles or privileges required for PL/SQL Developer (other than the connect role). However, the amount of information you can see is limited by the information returned for the Oracle user in the Oracle Dictionary views. Viewing information for objects that are not owned by you will typically require the DBA role (or system privileges such as "select any table"), or require explicit object privileges granted to your user.
Similar threads
- Discussion