2 Replies Latest reply on Aug 25, 2016 1:34 PM by 384d6584-f1c8-4c19-a180-b3b1b9ca3195

    Can't Edit Most User Source in SQL Developer

    384d6584-f1c8-4c19-a180-b3b1b9ca3195

      Hi,

       

      my user has no right to select from sys.dba_source, so I can't edit function, procedure etc. using sql developer.

      IDE gets the code from table sys.dba_source using this query:

       

      WITH src AS (SELECT ROWNUM,LINE,TEXT,origin_con_id FROM SYS.Dba_SOURCE

      WHERE TYPE = :TYPE AND OWNER = :OWNER AND NAME = :NAME)

      SELECT text FROM src, (SELECT max(origin_con_id) max_orig FROM src) 

      WHERE origin_con_id = max_orig

      ORDER BY LINE

       

      DBA doesn't want to grant access to this table because it contains all users source. Is there any way to force SQL DEVELOPER to use sys.all_source or sys.user_source?