Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't Edit Most User Source in SQL Developer

384d6584-f1c8-4c19-a180-b3b1b9ca3195Aug 25 2016 — edited Aug 25 2016

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?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2016
Added on Aug 25 2016
2 comments
400 views