Hi,
My instance version details are as follows:-
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
"CORE 10.2.0.5.0 Production"
TNS for Solaris: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
I have 50 users in this instance. One of the user is USR1. I want to create another user say USR1_RO, who should have full access to his schema and Read and Execute privilege for all the existing and new objects in USR1 schema alone.
I am new to oracle security concept. When I checked with my DBA he is suggesting me that the USR1_RO can have only read access to existing objects.and newly added objects to USR1 schema after the USR1_RO creation won't be visible to USR1_RO.
If read only access is given to all object to USR1_RO user then he will be able to see other user objects also say USR2, USR3. Which I don't want to happen.
Is there any work around available to get my wish fulfilled? A new user with Read and Execute Privs on another specific user objects (old and new). The issue I am facing with the suggested approach is when ever I add a new object to the usr1 schema I have to chase the DBA to grant the privs to USR1_RO. Also I don't want USR1_RO to see everything in my instance.
Regards,
Subramanian S.