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?