Resrcit schema's to access from diffrent tool
i need your experts guidence. actually i have a databse 11gR2 (11.2.0.2) running on Linux. DB have 15 customize schemas. and each schema is being accessed by diffrent application server. now problum is the same schema's are also being accessed by our develpment teams using diffrent tool like toad,plsql developer, SQL Developer or from SQLPLUS as well. but as per security point of view we wan to resrict the developent teams they can't access schema's using above mentioned tools but we agree to give them to just select their repective schema's tables and views.
so is this possible we can restrcit developemt team to just select tables and view when they are accessing schema's using toad,plsql developer, SQL Developer or from SQLPLUS tool.