1 Reply Latest reply on Mar 27, 2014 10:01 PM by thatJeffSmith-Oracle

    What permissions are needed in SQL Dev. to allow user A to see user B's tables.

    user563103

      I am a DBA on a 11.2.0.3 DB.

       

      User A has granted create any session, select any table, and select on all of user B's tables.

       

      In SQL Dev, he cannot expand the tables to see any of user B's tables.

       

      What other permissions/authorities etc are needed.  I know next to nothing about what is needed for SQL Dev.

       

      I did some searches but I don't think my search fu is working quite right.

      Thanks,

       

      JT