Hi,
I need to open up my database to a remote QA team.I want to ensure that they have read-only access to all my database objects (table records,procs, functions, views,etc) . But they should not be able to delete or drop database objects. How do i do that in oracle 10.2g ? Is there a built-in role which can be assigned to the user so he has only read access to the db. I dont want to manually choose all the database objects and assign execute/select privilege to each of them.I have close to 200 tables and 120 procedures.