I have a issue, Can you help me?
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 :
dba,select any table,connect,resource , create session,select on V$_session and...
alter user a grant Connect through B
User B ( proxy user) has permission :
Create session,select on any table, select on V$_session
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.
I tried with link
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/jjdbc/proxy-authentication.html#GUID-9DEFC135-8D15-4A24-8ECF-1E6FDE9AAAC7
but still not work.
P/S: Don't use another new user with read_only.
Regards,