Read Only Proxy User

 Hi,

i have two users A and B, can i request a help to create ready only  proxy user ie when user B connects to user a ( conn B[a]/B) as proxy user

then user should have read only permission,

 

User A has permission :

1. dba,select any table,connect,resource , create session,select on V$_session and...
2. alter user a grant Connect through B

User B ( proxy user) has permission :

1. Create session,select on any table, select on V$_session
2. user b does't have update permission.( update/ insert/drop/ truncate)

when user b connects to user a as proxy user then it should have read only  permission on the tables created by the user A.