Browser Information

[brc]

Currently Our developers do not have access to production, We would like them to be able to view source only. How can we accomplish that ?

 

[Marco Kalter]

The best way is to allow them to connect with a specific development user, which does not own the database objects. This way they cannot change anything.

 

[brc]

The developers login using their own credentials and do not own any objects, we have granted them select to certain tables.

They need to be able to view source of all procedures / functions / packages.

Is is possible to do that ?

Can you tell us which view is queried for populating the browser window ?

 

[Marco Kalter]

You will need to grant access to the all_objects and all_source views.

However, another user's package bodies and type bodies will only be visible if you have select privileges on the sys.dba_objects and sys.dba_source views. The "Use DBA views if available" preference (Tools > Preferences > Options tab page) needs to be enabled though.