We are looking for single sign on utility for PLSQL or oracle GUI developer tool. So we can assign UserB all the select permission on UserA schema (Current & future objects).
Currently, we have select Role UserA which we assigned to UserB and we use => (alter session set current_schema = UserA ) But we create lot of new objects (tables, view, mview...) and delete old ones very often and every time we have to assign the role select permissions.
Is there any easy way to do that?
Thanks In advance